It only truncates on the export. I can see the full memo field in the query.
Your question, however, walked me right into a somewhat odd solution:
I've tested a few things:
- Copy/paste (rather than export) from the query into Excel truncates the field - Copy/paste from the table...