TransferSpreadsheet not Updating Table

[Astello]

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?

 

[Astello]

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

 

[kalebson]

can we see the code?

 

[kevin_vdb]

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