Forum Discussion

drareve's avatar
drareve
Copper Contributor
Aug 22, 2020

Export to text wizard failing

I have a simple query (query1) that I want to export as csv text file. I am using a method I used successfully int he past but this time when I try it fails and reports "The Microsoft Access databas...
access
office 365
  • drareve's avatar
    drareve
    Aug 24, 2020

    I had not tried rebooting the PC. On doing so the issue went away. I should have tried earlier, it would have save a lot of time.

     

    Sorry this action has removed any chance of diagnosing the root cause, but the issue is now resolved.

George_Hepworth's avatar
George_Hepworth
Silver Contributor
Aug 23, 2020

drareve 

".... I am using a method I used successfully int he past...."

Which method is that? Knowing that detail could help someone think of a useful suggestion to try.

 

Thanks.

  • drareve's avatar
    drareve
    Copper Contributor
    Aug 24, 2020

    George_Hepworth 

    I have access to another PC where it works as expected. The steps are:

    1. From Access GUI: Right click query, select export > text file
    2. Define text file location and name (e.g. query1.csv). Do not tick boxes for Export data with formatting and layout. Select OK
    3. Select radio button “Delimited”, then Next
    4. Select radio button “Comma”, then Next, tick box “include Field Names on First row” and dropdown Text Qualifier as “
    5. On export to file prompt, reconfirm the same filename as specified in (2-), select “Finish”
    6. Don’t tick box “Save Export steps”, select “Close”