Import Specification "Record is too large"

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?
 
J

Joe Fallon

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fields are nested too deeply 2
Record Too Large 3
Can not import .csv file 1
problems importing a Paradox file into Access 2003 4
>> Search Key 4
Importing taxt extract file with Numbers and decimals 4
Importing FoxPro free table, getting around "the field is too small to accept.." error 1
Import error "The specification XML failed to validate " 4

Top