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.

 

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