VBA import,export, and run query

[ExcelTheCell]

Hi all,
Well this would be great if it could be possible and if someone could have the answer.
Lets say i have 3query's in database named Test1.

First Step (export)
Query1 and Query2 i would like to export in my documents and save them like excel table but changing the name to Query1T and Query2T.

Second Step (Import)
I would like to import above tables Query1t and Query2T to another database named Test2(that can also be found in my documents) and after close that database

Thirth Step(link and run)
I would like to import as link Query1T and Query2T to Test1 database and after that run Query3 from Test1 Database..Can you help me people?

Tnx,
​

 

[Joe4]

Take a look at the different Actions you can do via a Macro. You can run queries, import, and export. The Macro builder gives you all the arguments and help on what should be in each one.

If you name a Macro "AutoExec", it will run automatically upon opening the database (as long as Macros are enabled).

Also, if you need to make it more dynamic, on the Macro Toolbar there is an option to "Convert Macros to Visual Basic". So, if you create a Macro for one scenario, then convert the code to Visual Basic, you will have most of the code you need, and you can edit it to generalize it to suit your needs.