Export data into multiple sheets in Excel

B

Brian

Can anyone provide me with an example of exporting data
from access into a single Excel file with multiple sheets?
Access Help says that TransferText will do this, but I've
never been able to get this to work.
I need to be able to export similar data for different
users on to individual sheets, but bundle it up and send
as 1 workbook. (I am currently using docmd.OutputTo and
have been able to successfully generate separate
workbooks.) Thanks for your assistance.
 
H

Herbert Chan

Brian,

You should use TransferSpreadsheet (please look at the help and see if you
can figure out the syntax. If you can't just post back)

You can use TransferSpreadsheet and keep exporting to the same Excel file
(but it has to be from different queries/tables), then all the
queries/tables will sit neatly within one single Excel file.

HTH.

Herbert
 

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

Similar Threads

Export data to Excel Column 1
Exporting pivot tables to excel 1
Exporting multiple queries to multiple sheets within one excel fil 2
Access export to excel produces "unreadable data" 0
Export multiple queries to multiple Sheets in Excel 1
Merge Multiple workbook sheets into one workbook 0
Import multiple Excel sheets 3
Exporting Data to Multiple Tabs in Excel 1

Top