MS Access 2013 Memo Fields Truncated when exported to MS Excel 2013

[TrishaL]

Good morning,

I have multiple tables feeding to any of my queries.

When I export any of my queries that contains a memo field to excel the cells are being truncated. Many of my cells have 10,000 characters as an average.

I have hundreds of queries that are specific to what I need to export to excel so I am wondering if there is something that I can do that will apply to all my queries when I export to excel that have any of my memo fields with large amounts of data in it. There seems to no reason my the truncation is or is not happening. For example the one I randomly checked cut off at 3,982 characters and another at 3,973. I was hoping it was an exact character limit so that i could filter out the cells with the issues but it appears to be more random truncation.

Hoping someone can help. I have been reading with google search but I am unsure what exactly I should do and I am worried if I do something with a macro that any of my other queries or exports won't work. Just looking for help and clear direction on what I should be doing.

Thanks,
Trisha

 

[mole999]

excel will show 255, the cells are not designed to hold memo data levels