Is there a record length limit when importing into access

S

sasha05

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

Jerry Whittle

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

John Vinson

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

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]
 

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

Mail Merge skipping records/sending one at a time 0
Merge Excel file into Word Document 3
A problem occurred running while microsoft access was communicating with OLE server or ActiveX Control. 0
Autonumber field in Excel that behaves the same as Access 0
Check length for each record for a delimited file 4
Import csv - unparseable record 2
unparsable record 2
Adding data to MS Access from csv file 0

Top