Import text file with hard returns

[Lars Brownies]

I'm trying to import a text file of which the values are separated by "|".
It works well but some of the records have a field value that contains a
hard return (shows as a little box in the text). The import action chokes on
those records and enters a new record and the text behind the hard return is
lost.
Is there a way to let Access ignore the returns?
Thanks,
Lars

 

[Tom Wickerath]

Hi Lars,

If this is a one-time need, try importing into Excel first. If that is
successful, then save the .XLS file and use that as the source file for your
import. Excel seems to handle difficult data better than Access, in my
opinion.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[Lars Brownies]

Thanks. Got it working.

Hi Lars,

If this is a one-time need, try importing into Excel first. If that is
successful, then save the .XLS file and use that as the source file for
your
import. Excel seems to handle difficult data better than Access, in my
opinion.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________