Import text file with hard returns

  • Thread starter Thread starter Lars Brownies
  • Start date Start date
L

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
 
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/
__________________________________________
 
Thanks. Got it working.

Tom Wickerath said:
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/
__________________________________________
Click to expand...
 
Back
Top