Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ADO Connection import recordset into Access Table

Status
Not open for further replies.

r15gsy

IS-IT--Management
Jan 9, 2008
22
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
 
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
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top