Getting an error importing a test file

[Guest]

I have a comma delimited text file that has been down loaded from a IBM
mainframe. I can open it with WordPad and Import a small version of it into
Excel. When I try to import the small or the large version of the file into
Access, I get the following error:

One or more rows of your data file contain too many characters to import.
The maximum characters per row is 65000.

After I click OK to the error message, the wizard starts. The data that is
being displayed looks like a Chinese Character set. What could be worng?

 

[John Nurick]

At a guess the file has just CR - Chr(13) - or maybe LF - Chr(10) at the end
of each line instead of the Windows standard CRLF. Recent versions of Access
are fussy about this.

If this is a one-off task, try opening the file in Notepad or another text
editor and doing Save As. This will probably fix the line breaks. If it
doesn't, search the internet for a utility program that will do the job,
(there are lots) using keywords like
convert text unix mac dos

 

[Guest]

It turns out the file had some nulls in it and that was causing the problem.
The error message Access is giving is very misleading and should be fixed.