Import Specification "Record is too large"

  • Thread starter Thread starter A Williams
  • Start date Start date
A

A Williams

I imported a text file of over 200 fields and applied an
import specification skipping more than 50 fields.
However the import fails and I get an error "Record is too
large". What does this mean? How do I resolve this?
 
It means the file is not built correctly.
Each line has to end with a vbCRLF which is Chr(13) & Chr(10).

You may only have one or none of them as a row terminator.
Thus Access is trying to read the entire file as the first row and fails.
 
Back
Top