SteveL13
asked on
Cannot import more than 255 charaters from an Excel cell to a table field
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?
--Steve
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?
--Steve
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER