Getting an error importing a test file

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
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.
 
Back
Top