255 character limit on query fields (1 Viewer)

HairyArse

Registered User.
Local time
Today, 01:44
Joined
Mar 31, 2005
Messages
92
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

Well-known member
Local time
Yesterday, 21:44
Joined
Apr 9, 2015
Messages
4,339
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

MVP / VIP
Local time
Today, 01:44
Joined
Jan 14, 2017
Messages
18,186
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
 
Last edited:

Users who are viewing this thread

Top Bottom