XML import into Access – Workaround for text truncation (2006) Posted on February 17, 2016 by jgordon Link. “first import just the structure, then change the datatype from text to Memo”. I still get comments on this one.