billHassall
Registered User.
- Local time
- Today, 12:36
- Joined
- Feb 25, 2010
- Messages
- 27
I am trying to export multiple queries into existing worksheets within the same spreadsheet, but instead of the export overwriting within the existing worksheets, it is creating additional worksheets with the same name plus a "1" suffix. I could rename the queries to the worksheet names, but would prefer to leave the query naming conventions and just specify the name of the worksheet that I want to export to
Any help would be appreciated, I am on Access 2010 and the code is as follows:-
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "12 Monthly Day 6 5R", MyPath & "\Day 6 Delivery.xls", False, "5 Region"
I want to export query "12 Monthly Day 6 5R"
into file "Day 6 Delivery.xls"
and overwrite worksheet "5 Region"
Bill
Any help would be appreciated, I am on Access 2010 and the code is as follows:-
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "12 Monthly Day 6 5R", MyPath & "\Day 6 Delivery.xls", False, "5 Region"
I want to export query "12 Monthly Day 6 5R"
into file "Day 6 Delivery.xls"
and overwrite worksheet "5 Region"
Bill