Automatic Databases Link (Link Tables)

[BluesPhone via AccessMonster.com]

I need help creating a script to automatically link 2 databases from 2
servers. I have successfully connected 2 databases manually under Get
External Data --> Link Tables, and I have run the query to get the right
result.

The question now is how can I run this query in the middle of the night with
automated links to the databases, and then run the query, export out the
result set to Excel, and then terminate the links

Your help would be greatly appreciated.

Jon

 

[BluesPhone via AccessMonster.com]

I also like to add that the databases are in MySQL databases.

Thanks again, and I am anxious for your help

Jon