S
scott
I export data from a non-Access database that has two fields - the id and a
memo field that can have lots of carriage returns - to a txt file. The first
field is length delimited (8 characters), which is fine. The txt file treats
carriage returns in the memo field as hard returns, which makes importing the
data to Access a problem because it treats each carriage return as an end of
record marker. Using MS Word, I succeeded in replacing the hard return with
a soft return because the number of spaces after the hard return is unique,
but I am unable to import the data. If I save the file as txt, it just puts
a hard return where the soft return was and I'm back where I started. I
can't save it as a Word doc (or rtf) and import it (.doc and .rtf are not
options - if you can tell me how to make one of them an option and you think
this is the best way to do this, please tell me how to do this). I've tried
a lot of things (putting it in Excel first, changing the filed delimiter,
etc.). I've run out of ideas.
Any help?
memo field that can have lots of carriage returns - to a txt file. The first
field is length delimited (8 characters), which is fine. The txt file treats
carriage returns in the memo field as hard returns, which makes importing the
data to Access a problem because it treats each carriage return as an end of
record marker. Using MS Word, I succeeded in replacing the hard return with
a soft return because the number of spaces after the hard return is unique,
but I am unable to import the data. If I save the file as txt, it just puts
a hard return where the soft return was and I'm back where I started. I
can't save it as a Word doc (or rtf) and import it (.doc and .rtf are not
options - if you can tell me how to make one of them an option and you think
this is the best way to do this, please tell me how to do this). I've tried
a lot of things (putting it in Excel first, changing the filed delimiter,
etc.). I've run out of ideas.
Any help?