Unanswered: Access Export into Excel - Won't maintain link
I have a export set up in my Access table to export a query into a Excel spreadsheet, which works fine using a macro command Output to. I then have another Excel file I set up links to this file to pull information out of. The links set up fine, but when I ran the program a second time and tried to open the Excel file with links to the exported Excel file from Access, I am getting the message "Unable to Read File". I have tried all types of Excel export options with no success, any suggestions from this great group of users?