Export data into multiple sheets in Excel

  • Thread starter Thread starter Brian
  • Start date Start date
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.
 
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
 
Back
Top