I had this problem once before and thought I had it solved but I guess not.
I'm trying to import an Excel file into a table in Access 2013. One of the fields contains many more than 255 characters but the import process WILL NOT import more than the first 255 characters! Is very frustrating.
I have done what some exports suggested before including:
1) Be sure one of the first 25 rows I the Excel file have more than 255 characters. Actually, they all do.
2) Link to the Excel file and try an append query to the table. Doesn't work either.
Any other thoughts?