runtime error 3010

[nicklewisj]

Hi All,

You proberly have seen this before but attemptin to simply transfer a query results into a spreadsheet using

DoCmd.TransferSpreadsheet _
TransferType:=acExport, _
SpreadsheetType:=acSpreadsheetTypeExcel97, _
TableName:="query_name", _
FileName:="file", _
HasFieldNames:=True

there is five in total being run but on the last it decides to go to error 3010 table 'name' already exists even though all the others exist isa there something access end or excel end that is stopping this

any ideas why/how you can stop/fix this would be much appreciated