Discussion Locked

Problem with Access export

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am trying to create an export file in .CSV format via a query. After I've named the file and clicked the "Finish" button, I get this message from the Export Text Wizard: "Invalid argument". When I click "OK" I get this unhelpful explana- tion: "Anerror occurred trying to export data from table 'Customer_Query'. The data was not exported." The export file, of course, is not created.
Can anyone provide information on what is going on here?

5 replies

by mous

i would have the query be a 'make-table' query then export the data.

by richtee

I have had similar problems and it always ended up being problems with date formats.

A quick Trouble shooting step would be to try a sample export without using dates in any fields. If your export works then you know that the date formats are causing your problem and proceed accordingly.

Good Luck.

Rich

This discussion is closed to new replies.