Create a macro using 2 db

[Guest]

Hi,
I need to create a macro that will run a query in mdb1, then run a query in
mdb2, and then again a query in mdb1.
Is it possible?
Please answer me as if I was a kid because 1) english is not my native
language and 2) I don't know well vba and co. Thanks!

 

[Steve Schapel]

LD,

What type of query do you have in mind?

Is it possible to link from one mdb to the tables in the other, so that
the queries can all be run within one application?

 

[Guest]

My first query is in mdb1, it erases all 2007 data in the master table in mdb1.
My 2nd query is in mdb2, it loads all the new 2007 data (which are in mdb2)
in the master table in mdb1.
I'd like to create a macro allowing me to do all the process in 1 click (I
have to do it weekly).
Thanks!