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

TrishaL

New Member
Joined
Jul 9, 2013
Messages
49
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

Moderator
Joined
Oct 23, 2004
Messages
9,899
excel will show 255, the cells are not designed to hold memo data levels
 

Forum statistics

Threads
1,082,557
Messages
5,366,304
Members
400,882
Latest member
zaldy_a

Some videos you may like

This Week's Hot Topics

Top