| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
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. -- Ken Snell <MS ACCESS MVP> "DianePDavies" <(E-Mail Removed)> wrote in message news  9A3EFCD-065F-454F-ABA0-(E-Mail Removed)...> 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? > -- > Diane |
|
|
|
|
|||
|
|
| |
|
Guest
Posts: n/a
|
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. -- Diane "Ken Snell [MVP]" wrote: > 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. > > -- > > Ken Snell > <MS ACCESS MVP> > > > "DianePDavies" <(E-Mail Removed)> wrote in message > news 9A3EFCD-065F-454F-ABA0-(E-Mail Removed)...> > 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? > > -- > > Diane > > > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
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> "DianePDavies" <(E-Mail Removed)> wrote in message news:47608C2A-289C-47B3-BE9A-(E-Mail Removed)... > 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. > -- > Diane > > > "Ken Snell [MVP]" wrote: > >> 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. >> >> -- >> >> Ken Snell >> <MS ACCESS MVP> >> >> >> "DianePDavies" <(E-Mail Removed)> wrote in message >> news 9A3EFCD-065F-454F-ABA0-(E-Mail Removed)...>> > 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? >> > -- >> > Diane >> >> >> |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Re: Cut and "insert cut cells" in Excel 2007 doesn't work. | GS | Microsoft Excel Misc | 9 | 29th May 2012 10:36 PM |
| cut-off text in cell.. I want excel to cut-off the text after # of char. | qripatches@gmail.com | Microsoft Excel Misc | 3 | 17th May 2006 05:01 PM |
| Paper & cut cut cut ... | muckshifter | General Discussion | 1 | 24th Dec 2005 12:44 AM |
| cut & paste with short cut keys (ctrl C V) with absolute cell refe | =?Utf-8?B?TW9kZWxsZXIgRGF2ZQ==?= | Microsoft Excel Misc | 1 | 8th Dec 2004 12:14 AM |
| Cut and Paste Wide Spreadsheet in Powerpoint, spreadsheet gets cut off | Paul DeSaro | Microsoft Excel Programming | 2 | 22nd Apr 2004 12:01 PM |
