I have a database with two queries I'm trying to export to an Excel spreadsheet. The query names are:
BP_Output_NC
BP_Output_TCSC
I have a spreadsheet with two tabs already formatted named:
NC
TCSC
I'm trying to use the docmd.transferspreadsheet command to make this happen but when I specify the tab "NC!", I receive the error "Table 'NC$' already exists. Any idea what I'm doing wrong.
Here is the acutal code:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "BP_Output_NC", "\\Mer2-corpfs1\dnsc\Resource Management\Resource Management Weekly Booking Profile\Template.xls", 1, "NC!"
Thanks