troubleshooting Question

Long Text field being truncated during import

Avatar of Errol_Isenberg
Errol_IsenbergFlag for United States of America asked on
Microsoft Access
3 Comments1 Solution119 ViewsLast Modified:
Good morning, Experts.
I have the problem described below and I am hoping at least one of you can help me with it.
I have an input file Q.xlsx that I format with QualityRecords.xlsm and then import into an Access DB QualityReviews.accdb which contains the table Reviews.
The formatting program and the import process are automatically executed when the DB is opened.
The input file contains some text fields that are concatenated into a column titled Comments, which is column W on the QualityReviews tab in the QualityRecords.xlsm workbook.  The cells in this column have a General format.  The contents in this column can be more than 255 characters in length.
The formatting program properly creates the contents in Column W.
In the DB, the records from QualityRecords.xlsm are imported into the Reviews table.  The Comment field in the Reviews table has a data type of Long Text.

After the records are imported into the DB, the content of the Comment field in the Reviews table is truncated at 255 characters, as if it is a Short Text data type.  
Can any of you explain this, and please tell me how I can get the full content of the Comment column from the QualityRecords.xlsm program in the Comment field in the Reviews table of the DB?
The relevant files are attached.
Thank you in advance for your time, and for any guidance you can give me in this matter.
Q.xlsx
QualityRecords.xlsm
QualityReviews.accdb
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 3 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros