Table <name> already exists. (Error 3010)

[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"

 

[Dennis]

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.

 

[Pietro]

Thank you Dennis for your reply...
Wcan i do to export my table and leave the first two raws empty in Excel ?

 

[Dennis]

I think all you can do is insert 2 blank rows manually after you have exported

 

[a a r o n . k e m p f]

uh can't you start pushing to a range that starts in A3?