Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2005
    Posts
    121

    Unanswered: Access Export into Excel - Won't maintain link

    All,
    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?

  2. #2
    Join Date
    Jun 2007
    Location
    Maitland NSW,Australia
    Posts
    388
    For some reason the file maybe still open.

    Have you tried making a table with your data and then using the TransferSpreadsheet command in the macro?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •