Importing data from excel to memo field in Access is truncated after 255 characters

[tungkee831]

I haven't seen anyone run into this particular problem on this forum...

I'm importing data from an excel spreadsheet to an MS Access (2007) table. One of the fields in the table is a text memo field able to support more than 255 characters...

Issue:
The issue is that any cell in Excel that is greater than 255 characters is truncated when imported to MS Access even though the field is a memo field. There isn't any documentation on Microsoft's website about this and I don't see any way to work around it other than manually copying the data from excel to MS Access.

Anyone have any input on this matter?

Thanks in advance!

 

[RuralGuy]

See if there is anything in this link that helps explain the issue.

 

[KenHigg]

Good read - Thanks.

 

[RuralGuy]

You're welcome Ken.