Problem with data trunked if I import them from excel

[Guest]

Hi, my customer has a problem when import data from excel. When the employers
import data from an excel cell that is more extended of the access table
field, this data it’s trunked, but access doesn’t create the error table (I
don’t remember correct table name): why? Where is the problem? How enable
this table?



Thank’s

 

[G. Vaught]

If the data in the Excel field is greater than 255 charaters and you are
importing the data into an Access field with the datatype of Text, it will
only give you the first 255 characters. All other characters are 'chopped
off'.

On another note, expand the field to ensure the text is getting truncated
and it is not just showing because the fields size is too small. This is not
the same as the datatype size. I am referring to the physical size of the
field.

Try changing the Access datatype to Memo. Be aware that you still may get
truncated data. I've have heard that anything over 255 characters is
classified as BLOB data, it sometimes requires you to pass 100 characters at
a time via concatenation. In other words, special handing.

Check Access Help for BLOB data.