Table already exists

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.
 
J

Jeff Boyce

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>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing Data when primary key already exists 2
Export Delimited 1
Exporting with Range? 2
Transferspreadsheet and replacing existing data 2
How do I copy a column of Excel data into an Access table? 3
transferspreadsheet query - adding duplicates to lookup tables 2
Need to name range/transfer spreadsheet 4
Importing text file using spec into existing table..same as append 2

Top