How to Create a Table from the recordset value

Question

How to Create a Table from the recordset value

sqlCardEvent1 = "select * from tmp_CARDEVENT"
    If rsCardEvent1.State = 1 Then rsCardEvent1.Close
    rsCardEvent1.Open sqlCardEvent1, Cn, adOpenStatic, adLockOptimistic
    cmdCardEvent1.CommandText = sqlCardEvent1
    Set rsCardEvent1 = cmdCardEvent1.Execute

    sql33 = "create table tmp_date1 from"  & rsCardEvent1 
    rstmpDATE1.Open sql33, Cn, adOpenStatic, adLockOptimistic

Need SQL Query Help?

Answer 1

You would do it in SQL and use the ExecuteNonQuery method of SqlCommand:

sqlCardEvent = "select * " & _
    "into tmp_date1 " & _
    "from tmp_CARDEVENT"
cmdCardEvent1.CommandText = sqlCardEvent
cmdCardEvent.ExecuteNonQuery