Avoid truncation

E

EllenM

Hello,
One of the fields in my Excel file has more than 255 characters. When
importing into Access, that field gets truncated. Can someone help me?

Thanks,
Ellen
 
K

Klatuu

The maximum length of a text field is 255 characters. If you are importing
to a new table, it will default to a text data type and truncate the field.
You can solve this by defining your table in design mode and make the field a
memo data type and import to the existing table.
 
Top