Import multiple tables

R

rmcompute

I have to import 4 tables from each of 15 branch applications for a total of
60 tables. Since it would have to be done every time I bring in data, I set
it up in VBA as follows to import the tables:

DoCmd.TransferDatabase acImport, "Microsoft Access", strPCMan, acTable,
"tblEmployees", "tblEmployees"

The only issue I have is that when I do it manually, I can connect to each
branch and click all 4 tables simultaneously, which then import quickly.
The time lost is on making the connection. When I do it in VBA, is there a
way to bring in all 4 tables at once as can be done manually ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting Multiple Tables 1
Setting column width in a table with a macro is not working 0
List all tables, including document structure 0
Embedded Excel into Word with Tables 0
batch extract all tables from multiple word documents 1
Consolidation Table from Different Excel Tabs with Different Format 1
Embed the same Excel multiple times 0
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2

Top