Table <name> already exists. (Error 3010)

  • Thread starter Thread starter Pietro
  • Start date Start date
P

Pietro

Hi,

I'm trying the below code to export my query into a certain excel sheet
and in a certain range without exporting the fields,i get the error "A3:M7"
Already exists.
Here's the code:
DoCmd.TransferSpreadsheet acExport, 8, "Tier2 Today's Report",
"O:\XBOX\XBOX-Tier2\Customer Support\Source\Reports\Tier2 Report.xls", ,
"A3:M7"
 
Look at the help for TransferSpreadsheet, it says that specifying the range
is only for Import and that if you specify it for export, you will get an
error and it will fail.
 
Thank you Dennis for your reply...
Wcan i do to export my table and leave the first two raws empty in Excel ?
 
Back
Top