I have a TransferSpreadsheet macro that's supposed to overwrite an excel file with new data each time it is run (the access table is updated each time in a query). However, the data isn't being rewritten. I've checked the table and file names, and the query is correct. Any ideas?

Does it help to say that there is a macro in the excel file i'm exporting to?

can we see the code?

It might help if you do a refresh of your table before you run the update query.