May 20, 2016

MS Access 2013 Long Text Issue

I am attempting to import/append more than 255 characters from Excel into MS Access 2013 long text field, however it truncates the field and only shows 255 characters. HELP!
From what I've read on this issue, it's due to how access pickups up formatting on import. The easiest workaround seems to be importing the data into a temporary blank table and then append it to yours.
Answer this