multiple queries to same excel workbook

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
 
K

Ken Snell

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

Beginner

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>




.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top