Probably in the macro recorder. Select the sheet and do Get = External
Data.

Modify the recorded code to handle each of the databases you want to import
to be placed in the proper location.

--
Regards,
Tom Ogilvy


"Danail" wrote in message
...
I've seen this code somewhere- please
give me a template code in Excel VBA - i want to open
(from Excel ) multiple MS access queries and copy them
automatically to multiple worksheets .

Help!!

Danail