multiple queries to same excel workbook

  • Thread starter Thread starter Beginner
  • Start date Start date
B

Beginner

I have 3 different queries to be output to a single excel
workbook as three different sheets.

Right now, I have a macro with the different queries
outputting to 3 different excel workbook

Any help is highly appreciated.

Thanks in advance
Beginner
 
Use the TransferSpreadsheet action and use the same filename for each of the
three actions. ACCESS will add worksheets to the EXCEL file.
 
Thank you. It works...

-----Original Message-----
Use the TransferSpreadsheet action and use the same filename for each of the
three actions. ACCESS will add worksheets to the EXCEL file.

--
Ken Snell
<MS ACCESS MVP>




.
Click to expand...
 
Back
Top