Data export form table broken

Hi All,

I have a table from which I want to export the data as a plain text
file.
I exported the data using the "Export" option and selected the comma
as a separator and the " as the Text Qualifier.

I have about 19800 records but a few hundred are broken over multiple
lines.
That is, the majority of records are exported correctly but some of
them are split up into more than one line?

For example this is a record: (selected via running a select from
query)

134S United States Of America 11695 "Woodland Hills - Oxnard
, 21550 Oxnard Street, Main Plaza" Woodland Hills California 91367
No No No No Site02720 Branch - Smith Barney & Private
Bank
When Access writes it out to a text file, the record is being split
after the first occurrence of the word "Oxnard" and I'm not sure why
this is happening.

Any suggestions?
Thanks,
Sashi

re: Data export form table broken

On Jul 10, 2:37 pm, Sashi <small...@gmail.comwrote:All, I found the problem. I receive this data from another source and
it turns out that there are line breaks in the middle of a field.
To get rid of the line breaks, I'm running the following command:
UPDATE [tbl_CircuitData-Musto] SET FromLocation =
Replace(FromLocation,Chr$(13) & Chr$(10),'\n');
However, this still doesn't work.
Any help?
Thanks,
Sashi

re: Data export form table broken

Sashi <smalladi@gmail.comwrote in
news:1184165931.754859.13850@r34g2000hsd.googlegro ups.com:
'\n' doesn't do much, just use " "

Some text files don't use chr(13) & chr(10), just one or the
other.try replacing chr(13) with " " and see if that helps



--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com