255 character limit on query fields

[HairyArse]

I have a query, the results of which are pasted into a spreadsheet template for a monthly KPI report that goes to one of our biggest customers.

The problem is (and I know that this is old news) Access's 255 character limit on fields in a query. Even fields set to longtext or blob get cut off at that 255 character limit.

I need the results of this in a datasheet query in order to paste into Excel and maintain the correct columns. Without anything cut off.

Has anyone figured out a way of getting around this? And if not is there another solution?

 

[Ranman256]

The export will truncate a query.
Try copying the data to a table. This should keep all the memo text.
(Append qry)

Then export the TABLE, (not a query) and it should export the entire text.

 

[isladogs]

I disagree with both previous posts

You can create queries based on memo fields without truncation
Similarly you can export those query fields without truncation
I've just double checked the latter for query fields with around 1000 characters

In both cases you just need to ensure the data has not been processed in any way.

Allen Browne explains both the reasons for truncation & how to avoid it here:
http://allenbrowne.com/ser-63.html

HTH