Knowledge Base

Some Special Characters Are Changed in Imported Files

Article ID: 111397

Article Last Modified on 8/15/2003

APPLIES TO

This article was previously published under Q111397

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.

Additional query words: 5.00a 5.00c 8.00 97 XL97 dBASE dif dbf import XL

Keywords: KB111397


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.