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