Thread: [Solved] * Exporting Access Data to Excel
View Single Post
 
Old 03-23-2012, 05:49 PM
djreyrey djreyrey is offline Windows 7 Office 2007
Novice
  
Join Date: Mar 2010
Posts: 21
djreyrey is on a distinguished road
Default * Exporting Access Data to Excel
Hello Everyone,

Thank you for your help! I'm using the following code in Access to export data to Excel. It works fine but each time I export, it creates a new Tab in the Excel spreadsheet. Is there anyway to specify the name of the tab I want to export to and use the same tab every time?
Code:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, _
"tblAdvancedPricing", outputFileName, True, "AdvancedPricing"
?

I would really appreciate your assistance!
Reply With Quote