Table already exists

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there! Using A02 on XP. Have a macro to export data to Excel 5-7 with
TransferSpreadsheet and named a query in the Table Name action argument.
Worked the first time but now it says the table already exists. My file name
is good and I'm not using range. Of course the query already exists, but I
just want to 'run' it again. Can't figure out what happened.

Thanks in advance for any help or advice.
 
Bonnie

Is it the table that already exists, or the Excel file? What happens if you
rename the Excel file and try re-running the macro?

Regards

Jeff Boyce
<Office/Access MVP>
 
Back
Top