Export from Access to Multiple Excel Sheets
Posted on 2011-02-13
I can successfully export a table/qry from Access to Excel using ransferspreadsheet. I would like to take this another step and, when exporting a table, create a seperate sheet for every account that it is in the table. The number of accounts can fluctuate in the table (which is created by a qry). I would also like the sheet names to be the name of the account. Is this possible? I currently just overwirte the existing Excel workbook, but it would nice if I could choose to save this file when run instead of always overwriting the file and then opening/saving somewhere else.
Thanks in advance.