Forum Discussion
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...
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.
".... 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.
I have access to another PC where it works as expected. The steps are:
- From Access GUI: Right click query, select export > text file
- Define text file location and name (e.g. query1.csv). Do not tick boxes for Export data with formatting and layout. Select OK
- Select radio button “Delimited”, then Next
- Select radio button “Comma”, then Next, tick box “include Field Names on First row” and dropdown Text Qualifier as “
- On export to file prompt, reconfirm the same filename as specified in (2-), select “Finish”
- Don’t tick box “Save Export steps”, select “Close”
