Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    St. Louis, MO

    Unanswered: Exporting to Excel is not an option

    I recently reloaded Access and I have a function that used to export many queries into Excel. Now I get the following error:

    "Run-Time error 3027. Can't Update. Database or object is read-only."

    I do have all the same references that I used to including to the Excel 10.0 library.

    Upon further investigation I found that when I right click a query and select "Save As/Export", Excel 97 is no longer an option in the drop down list of file types.

    When I reloaded Access, I selected "Install All", so the Data Access Object should be there.

    Can you recommend anything?


  2. #2
    Join Date
    Jun 2002
    Houston, TX
    I had a similiar problem and found on Microsoft knowledge that a Jet Engine service pack was required to be installed to fix it. I'm sorry I don't have that site available, but I did a search on the error message I was getting and found.


Posting Permissions

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