MS Access Export not updating File

I'm having a problem with exporting an Access query to an Excel file.  The database in question is stored on a shared drive while the export file is stored on my local disk.  I'll run the query, then use the Export to Excel wizard under External Data to send the data to Excel.  The wizard will run, ask me to replace the existing file, and once I've given it permission to overwrite the file it completes its process.  It tells me that the export was successful.  However, my Excel file isn't being updated or overwritten.  It's still filled with the old data.  I'm forced to delete the file and rerun the Export Wizard in order to export the data to a file using that Excel file's name. 

Why is the Wizard telling me it's successful when the data in the Excel file isn't being updated?  There's a disconnect somewhere but I can't figure it out.  If anyone's encountered this before please let me know and what you did to solve the problem.  Thanks.

 

Question Info


Last updated December 6, 2019 Views 779 Applies to:
First, when you run the wizard manually are you sure you are specifying the same file that you are subsequently opening? 
Hope this helps,
Scott<>
Blog: http://scottgem.wordpress.com
Microsoft Access MVP since 2007

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Hi Scott.

I am 100% sure I'm opening the file I navigated to in when browsing in the Export Wizard.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Hmm, I'm at a loss then I just tested this and it worked fine for me. 
Hope this helps,
Scott<>
Blog: http://scottgem.wordpress.com
Microsoft Access MVP since 2007

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

It normally works for me as well.  In fact will occasionally have it work in regards to this specific query and file.  But it's failing to update often enough that I felt it necessary to try and troubleshoot.

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Just in case the naming architecture is called into question, the name of the query and the Excel file are the same: "Qry_1_LIVE"

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

I've had this issue as well.  Found that if I save the query prior to exporting then I get the correct result.

9 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.