Exporting several queries into Excel

[dbguy11]

Hi know there is a way to do this. I have a large table that I export into
excel. I break down the big table by having a query for each of the different
sites that are listed in the original table. That gives me like 35 tables,
which I right click and export into the same excel file that I exported the
original table into. Each one of the queries is named for site that it
contains. How can I export these files automatically into one excel file into
separate tabs for each query and have them retain their original name that is
on the queryfor the tab name. It's not necessary that I be able to export the
main table if it makes things easier.
Thank you in advance for any help you can provide me with on this issue.

 

[Dale Fye]

search on CopyFromRecordset in the FormsCoding newsgroup. There is a thread
there "Export to Excel - but not with TransferSpreadsheet" that talks about
use of this method. In particular, look at the samples provided by Klatuu
(Dave Hargis).

If you are not familiar with Excel automation from Access, search for that
as well.

HTH
Dale