XL: Some Special Characters Are Changed in Imported Files

 Last reviewed: December 17, 1996
Article ID: Q111397
The information in this article applies to:
  • Microsoft Excel for Windows, versions 5.0, 5.0c
  • Microsoft Excel for Windows NT, version 5.0
  • Microsoft Excel for Windows 95, version 7.0
  • Microsoft Excel 97 for Windows

SUMMARY

In Microsoft Excel, the data source character set for various file types is not available in the Open dialog box (from the File menu, choose Open).

MORE INFORMATION

You cannot specify the character set when you open a file in Microsoft Excel. For instance, dBASE files will always be imported using the ASCII character set, and FoxPro for Windows will generate ANSI-DBF files. As a result of this automatic character formatting, some special characters may be lost or displayed incorrectly. For example, international characters, such as French and German accent marks, may be converted to their corresponding characters in default character set.

KBCategory: kbusage
KBSubcategory: xlloadsave
Additional reference words: 5.00 5.00a 5.00c 7.00 8.00 97 XL97 dBASE dif
dbf import

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: December 17, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.