Memo-field is cut off in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I want to analyze the result of a quesry in Excel, my memo-fields get
cut off at the length 255.

How do I increase that limit?
 
You don't. "Analyze with EXCEL" uses EXCEL 95 format, which is limited to
255 characters in a string and 16384 rows in a sheet.

You probably should look at using ACCESS's tools to do what you seek.
 
Well I dont "analyze" - I use it for an easy way of providing info to others
in a familiar format - allowing them to sort columns etc. But then the
memo-fields get cut off.
 
Check out the TransferSpreadsheet method in ACCESS. You can run it from a
macro or VBA code. It allows you to use the newer formats of EXCEL, and the
memo field is not automatically truncated.

If you export a query, and you're using the Replace function in a calculated
field that involves the memo field or you're using a GROUP BY clause with
the memo field, or you use a union query with UNION (instead of UNION ALL),
the memo field will be truncated.
--

Ken Snell
<MS ACCESS MVP>
 
Back
Top