outputting multiple queries into one Excel file

[Dima Khantsis]

I have multiple queries in Access that I would like to
output to one excel file. Is that possible utilizing the
macro functions in Access or am I going to have to do some
VBA coding to accomplish the task?

Thanks for the help.

Dima

 

[Dima Khantsis]

Nevermind. Found the solution using TransferSpreadsheet
function in Macros. Thanks anyway.

 

[Steve Schapel]

Dima,

AFAIK, macros or vba the approach will be the same. Either you have
to export them one by one, using TransferSpreadsheet, or if
applicable, combine the queries into one prior to export using a Union
Query.

- Steve Schapel, Microsoft Access MVP