Copy data from ODBC data source to new Access table

[Phil Haddock]

Hi,

I'm converting an existing Access application to vb.net 2003.

The application allows users to select a number of tables from an ODBC data
source, and nominate names for each table to use in a local access table.
When they press the button, it deletes any local tables that exist and
recreates them using the new names, complete with current data.

In Access I loop through the list of tables and substitute the appropriate
names into this DAO query:

strSQL = "select * into " & tbl.tName & " from " & tbl.ODBCTName
Set qdf = db.CreateQueryD ef("", strSQL)
qdf.Execute

This automatically creates the new table and populates it.

I have everything working in my new application except this last step. I've
done a lot of googling and haven't found a clear description of how to do
this.

All the samples I've found seem to assume that you'll inspect the properties
of the ODBC table and build the new table specifying the column properties,
then load the data into a dataset and step through it one row at a time,
executing an Insert into the new table for each row.

Surely there's an easier way?

Thanks,