How to import multiple tables at once

[bethabernathy]

Hi - I was able to get my system to delete multiple tables, but now I need to import multiple tables from an .adp. named "sql_db". Is there a way to import all the tables from this database at one time? I am going to search around, but if anyone has any information or can help with the coding that would be great. Thanks, -Beth

beth@integratedresourcemgmt.com

 

[dhookom]

I am a little confused by your use of "import...from". Are you attempting to move records from SQL Server tables to Access tables or SQL to SQL or what? The best tool is DTS on SQL Server.

Duane
MS Access MVP

 

[bethabernathy]

Hi - We created a database as an .adp from the SQL server. We want to be able to run queries in on the data and have created an MS Access database so that the .adp is not disrupted as it is a live connection with the SQL server. So I need to find a way to import data from the .adp into the .mdb. I may have to import each table one by one using a macro, but was hoping to use a procedure. Any suggestions? Thanks, Beth

beth@integratedresourcemgmt.com

 

[dhookom]

You can either link to the SQL Server tables or create Pass-through queries to the tables. You can then append data to local tables.

Duane
MS Access MVP