Importing Error Access 2000

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I am transferring a file from an AS/400 dataquery in
a .txt format. I am then trying to either link or import
that text file into Access 2000. I have done this
numerous times with Access 97, but for whatever reason
EVERY time I try ti import into 2000 I get a system error.

Any thoughts?
 
Hi Steve,

One thing that changed between 97 and 2000 is that the text import
routine became fussier about the newlines in the textfile. It now seems
essential to have Windows-style CR+LF (Chr(13) & Chr(10)), and it's
possible that your AS/400 is using Unix-style LF (Chr(10)) only.

If this is the case and you can't change it, there are lots of utilities
on the web for converting textfiles between Unix, Windows and Mac
formats.
 
Back
Top