Export Multiple Tables to Excel Workbook
I would like the ability to export multiple tables/queries/etc.. to a single Excel Workbook. Currently, I can only export one table to a single workbook at a time. There are situations where I use Access to crunch some serious data in multiple tables and would like to be able to export all of them into a single workbook. As it stands, I have to export each one individually, then use the Excel Move command for the worksheets to combine them all to one workbook.

1 comment
-
Klaus Oberdalhoff commented
Already DOES work !!! If using transferspreadsheet it works since acc 1997
Just create different queries and use the same excel-sheet-name then the query name is the Tab-name within the ONE Excel-Sheet.