ADO Connection import recordset into Access Table

[r15gsy]

Hi

I have an ADO connection which opens an ODBC connection.

I can return a recordset and loop through the records.

What is the code to import the results into a local MS Access table.

I need to connect to 100 seperate ODBC databases and import 10 tables from each, so 1000 tables imported.

Thanks

 

[dhookom]

I would probably use pass-through queries and then use them as the source for append queries. Store the 100 ODBC connection strings in a table so you can loop through the table, update the connection properties of the pass-through queries, and run the append queries.

Duane
Hook'D on Access
MS Access MVP

 

[r15gsy]

Thanks for the reply.

That is exactly what I planned to do, but have failed.

I am using a custom ODBC driver with no documentation.

I can get it to work by setting up DSN in control panel, and by ADO connection. But if I try the exact same parameters anywhere else, including pass-thru queries, I get a reserved error 3000 (-7778) which I can find no solution for on google.

Any ideas appreciated.

 

[vbajock]

Post your code