Row Truncation errors during file import

[Mike Krailo]

I have no idea why it is creating this error on some rows of data. Can anyone figure this out?

 

[moke123]

Change all the fields to memo datatype. Imported without errors.

Ran a query to show the length of each record and some were 255. must be exceeding the text datatype limits.

 

[Mike Krailo]

Weird, I thought I tried using memo fields and had a different error. Let me try again. Edit: Well I don't know what happened the first time I tried that, I must have missed converting some of the fields. It imported fine after using long text. Thanks Moke123 for taking a look at it.

 

[Pat Hartman]

Text columns in tables are variable length so Access allows you to create record lengths that are longer than what it will actually support. When you add the lengths of all columns in a table, the total can't exceed something around 2K. Someone will post the actual number. The reason that importing into memo fields is because in the main table each memo field is just a couple of bytes (again, I'm not sure the actual length). The data for each long text field is stored in a separate, hidden table. That is why the memo field trick works.

 

[The_Doc_Man]

the total can't exceed something around 2K. Someone will post the actual number.

Actually, about 4K = the largest permitted disk buffer within Access.