Avoid truncation

[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

 

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

 

[EllenM]

Thanks so much!!