Exporting Table into CSV format, w/o erratic tabbing

  • Thread starter Thread starter Not_IT
  • Start date Start date
N

Not_IT

I have exported some large table data into a text file
needed to be deliminated by comma's with header
infomation retained on top, yet every 100 or so records
is tabbing erratically and corrupting the format.
Is there hope?
 
One possible cause is line breaks or other control characters in the
data you're exporting. Access usually exports these OK but not all other
software can handle text files containing them. Similarly, some
combinations of commas and quotes in the data can cause problems for
less intelligent software.

Also, make sure that you have installed the appropriate service packs
for your version of Access.
 
Back
Top