Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Las Vegas, Nevada, USA
    Posts
    334
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Unable to Export or Copy Query Results (Access 2003)

    I have an Access database which has been linked to an external source. I can usually run a query and select the results for copying into Excel. I have also been able to Export the results into a csv file to bring that into Excel. Up until today, anyway. Now the menu command Export is grayed-out and the progress bar when copying does not progress past one dot. I tried the Compress and Repair, but still no copying or Exporting is allowed.
    Suggestions for fixing this (these) problem(s) are greatly appreciated.

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Unable to Export or Copy Query Results (Access 2003)

    I have no idea what the problem is.

    Does everything else work as normal? Is your database connecting to the external source normally, and able to see the data ?
    Regards
    John



  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Las Vegas, Nevada, USA
    Posts
    334
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Re: Unable to Export or Copy Query Results (Access 2003)

    Good news. Good news. And not so good news.
    I can see that the results which are updated daily have updated to include yesterday's results.
    I found that by shrinking the query result set to select just yesterday's results. Then I tried copying and . . . Success! (But that's only 977 records and I usually query for around 40k records).
    But the Export function is still grayed-out from my query results and I don't remember that having been a problem before.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Unable to Export or Copy Query Results (Access 2003)

    Have you tried to compact and repair the database (Tools | Database Utilities | Compact and Repair)?

    If that doesn't help, try Help | Detect and Repair... (have your Office CD at hand).

Posting Permissions

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