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.
 
Back
Top