Exporting data to txt files

[coned]

This is probably very low-level but, I can't spin my wheels any more.

While exporting a 13000 record access table to a .txt type file, my records get out of order and some of the field data seems to mix together inadvertantly. Are there record number limits? Is there a special trick to exporting memo fields mixed with other text and date fields in one table?

There doesn't appear to be any real pattern to the exported data. I have to export from MSAccess to a .txt file in order to share with an external user.

Help!

 

[jsteph]

I'd check the text-delimiter, sometimes if you don't choose, say, the dbl-quote for text, it'll work fine until it hits a comma in the text, then every record after that is messed up.
--Jim

 

[Remou]

I do not think that you can export a memo field to a text file without some work. It is not unlikely that a memo field contains carriage returns and such like. The same may be true of other text fields.