Not so. Since Excel 97, you can have up to 32,767 characters in a cell,
though only 1024 will be displayed on the worksheet. Formulas are also
limited to 1024 characters - probably for the best, if you've ever tried
debugging 500-character formulas<g>.
These MS KnowledgeBase articles explain most (I think) of the reasons
memo fields and string expressions may be truncated to 255 characters
when exporting to Excel. One way to get to them is to include the KB
number (e.g. 281153) in a URL, e.g.
http://support.microsoft.com/?id=281153
ACC2000: When You Export an Access Report the Memo Field Is Truncated
(281153) - When you export an Access 2000 report in Microsoft Excel
97-2000 format, text in any Memo field that contains more than 127
characters is truncated to 127 characters.
ACC97: Memo Field Truncated When Report Is Output to Microsoft Excel 97
(182302) - When you output a report to Microsoft Excel 97, any Memo
field is truncated to 255 characters. You may also see this behavior
when you click the Analyze It With MS Excel command while you are
previewing a report.
ACC2000: Memo Field Truncated When Report Is Output to Excel
(208801) - When you output a report to Microsoft Excel, any Memo field
is truncated to 255 characters. You may also see this behavior when you
click the Analyze It With MS Excel command while you are previewing a
report.
ACC2000: Formatted Memo Field Appears to Truncate Data After 255
Characters
(259893) - When you apply formatting, such as a closing or opening
angle bracket (> or <), to a field with the Memo data type, the data in
the field appears truncated after the 255th character.
Memo field is truncated when you output a report to excel in Access
2002
(294286) - Lists two methods to address the issue that the memo field
is truncted to 255 characters when you export a report to Excel due to
the fact that Access outputs a report to Excel 5.0/95 format, in which
the maximum length of text-cell contents is 255.
The data in a linked Excel spreadsheet column is truncated to 255
characters in an Access database
(839785) - Discusses that the data in a linked table that is linked to
an Excel spreadsheet is limited to 255 characters in an Access database.
To work around this problem, import the Excel spreadsheet rather than
linking to the spreadsheet in your database.
ACC: Exported Query Expression Truncated at 255 Characters
(178743) - When you export a query that contains an expression that
results in more than 255 characters, the expression is truncated in the
exported file.
ACC2000: Exported Query Expression Truncated at 255 Characters
(207668) - When you export a query that contains an expression that
results in more than 255 characters, the expression is truncated in the
exported file.
Issues fixed in Access 2000 by Office 2000 Service Pack 3
(326605) - Microsoft has released Microsoft Office 2000 Service Pack 3
(SP3). This article describes the issues that are fixed for Microsoft
Access 2000. about how to download and how to install the Office 2000
Service Pack 3 (SP3) 326585 OFF2000: Overview of…
