Re: When exporting to excel, field will not exceed 255 characters.
- From: Klatuu <Klatuu@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 15 Mar 2006 09:26:29 -0800
Thanks for the correction.
"John Nurick" wrote:
On Wed, 15 Mar 2006 06:27:27 -0800, Klatuu.
<Klatuu@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
The maximum number of characters an Excel cell can hold is 255.
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…
--
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.
- References:
- Re: When exporting to excel, field will not exceed 255 characters.
- From: John Nurick
- Re: When exporting to excel, field will not exceed 255 characters.
- Prev by Date: Re: import DIF files into MSACCESS
- Next by Date: Re: Why do my linked tables not allow me to write to them?
- Previous by thread: Re: When exporting to excel, field will not exceed 255 characters.
- Next by thread: Re: import DIF files into MSACCESS
- Index(es):
Relevant Pages
|
