Article ID: 281153 - View products that this article applies to.
This article was previously published under Q281153
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.
To correct this problem, obtain the latest service pack for Microsoft Office 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
276367IMPORTANT: Before you install Microsoft Office 2000 Service Pack 3 (SP-3), you must have Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a) installed first.
(https://support.microsoft.com/kb/276367/EN-US/ )OFF2000: How to Obtain the Latest Office 2000 Service Pack
For additional information about how to obtain Office 2000 Service Release 1/1a (SR-1/SR-1a), click the following article number to view the article in the Microsoft Knowledge Base:
(https://support.microsoft.com/kb/245025/EN-US/ )OFF2000: How to Obtain and Install Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a)
Instead of exporting the report in Excel format, export it as HTML. However, this provides only a partial solution. When you open the file in Excel, the text in the Memo field will be spread over multiple cells instead of being in one single cell.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Article ID: 281153 - Last Review: September 23, 2005 - Revision: 4.2