Microsoft KB Archive/294951

= XL2000: Importing Text File Truncates Fields Longer Than 911 Characters =

Article ID: 294951

Article Last Modified on 1/6/2006

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q294951



SYMPTOMS
When you import a text file, Microsoft Excel may truncate some of the text fields to 255 characters.



CAUSE
This behavior occurs when all of the following conditions are true:
 * You use the Text Import Wizard to import the file.
 * The field is longer than 911 characters.
 * You do not use step 3 of the Text Import Wizard to set the data type of the field to Text.



RESOLUTION
To work around this issue, make sure that you set the data type of long text fields to Text. After being imported, the data may appear as number signs (###). To work around this behavior, change the format of the affected columns to General.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was corrected in Excel 2002.

Additional query words: long cell string open

Keywords: kbbug kbfix KB294951

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.