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