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 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