Does anyone know how I can copy an Access table using ADO code. I looked in the help for the SELECT INTO statement and I cannot seem to get it to work. The following is an example of what I am trying to accomplish:
rs.open "select * " & _
"into cable IN SQLDATABASE " & _
"FROM MDBDATABASE.TABLE"

Serge Suggested the following; however, I am not sure of the syntax:

Dim cn As New ADODB.Connection

cn.Open "DSN=MyDSN;UID=MyID;PWD=MyPassword;"
cn.Execute "Insert Into SQLTable Select * From AccessTable


Of course, your table structure should be the same in both tables.

This may work, but I want the table to be created as in a select into...Elias

Also, I am not sure of the exact syntax for "AccessTable"