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.