Macro to Link Tables

[djl0525]

Still crashing...

Can I write a macro that will import linked tables for me? Where would I put the list of tables I want to import?

DJ

 

[TheToeOfPooh]

I think this will point you in the right direction

Start with a Make Table Query using the linked table as your source.

Then construct a macro which starts with that query
Select Object (This will be the query you have just created)
Add a msgBox (to make sure you have correct source table)
Add some SendKeys (to automate the next few steps)
Add another MsgBox (to confirm everything is going to plan)
Run another macro (to name the table or manipulate the data as required).

HTH

Bernard

 

[Norie]

This is the general syntax to link a table from another database:

DoCmd.TransferDatabase acLink, "Microsoft Access", "C:\MyDatabase.mdb", acTable, "MyTable", "MyLinkedTable", False

Where would I put the list of tables I want to import?

There are various places you could have the list:

• a table
• an array
• a text file

 

[djl0525]

Thanks guys. I appreciate your input. While I waited to hear back from you I tried using Excel. I am currently using Microsoft Query to import the data from the Oracle database into an Excel worksheet. Excel has not lost the connection once. Everything is going according to plan. The new plan, that is.

DJ