Is there a record length limit when importing into access

[Guest]

I am importing a excel file into access and on certain records I am getting a
error message Unparsable Record

 

[Guest]

There is a record length. If memory serves, it's 2000 characters per record
and 4000 characters with Unicode. However there are two exceptions: OLE and
Memo fields. Also a text field can only have 255 characters each whereas a
memo field can have 64K characters.

The answer to your problem may be to convert some of the text fields to Memo
data type.

 

[John Vinson]

I am importing a excel file into access and on certain records I am getting a
error message Unparsable Record

There is a record size limit - but that's not the error message you'll
get when you exceed it, I don't think! It sounds like Access is
attempting to convert a value in one spreadsheet cell into an Access
datatype, and it's failing.

John W. Vinson[MVP]