outputting multiple queries into one Excel file

  • Thread starter Thread starter Dima Khantsis
  • Start date Start date
D

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
 
Nevermind. Found the solution using TransferSpreadsheet
function in Macros. Thanks anyway.
 
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
 
Back
Top