Export to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to export reports/queries to multiple tabs in the same excel
spreadsheet?

Basically export query1 to MainDoc.xls (query1 tab)
export query2 to MainDoc.xls (query2 tab)
etc....

I am using Access 2002 and Excel 2002.

I am using this code to export to a report to excel

DoCmd.OutputTo acOutputReport, "rpt_Test", "MicrosoftExcel(*.xls)", "",
True, "", 0
 
Look at the Transferspreadsheet function in the Help file. All you need to
do is use this function more than once.
 

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 query to excel 3
Export code not working in new version 2
Exporting a Report to Excel 2
export to Excel 1
Exporting several datasets to one Excel file 1
Export multiple datasets to one Excel file 1
Limit record count in query 1
export query data to excel in a specific worksheet. 2

Back
Top