Microsoft KB Archive/899600

= Text that uses umlaut characters may not correctly import in Office Access 2003 =

Article ID: 899600

Article Last Modified on 5/18/2005

-

APPLIES TO


 * Microsoft Office Access 2003

-





SYMPTOMS
Consider the following scenario. You try to import a file into a Microsoft Office Access 2003 database as a new table by using the Text Import Wizard. If the data in the file contains text that uses the following umlaut characters, these characters may not correctly import into Access 2003:
 * Ää
 * Öö
 * Üü



CAUSE
This issue occurs when the default code page for the Text Import Wizard is not set to Unicode (UTF-8). When a different code page is selected, the umlaut characters may be mapped to different characters.



RESOLUTION
To resolve this issue, follow these steps:
 * 1) In Access 2003, click Table in the Objects pane of the database window.
 * 2) Click New on the Database toolbar.
 * 3) In the New Table list, click Import Table, and then click OK.
 * 4) In the Files of Type list, click Text file (*.txt, *.csv, *.tab, *.asc).
 * 5) Locate and then click the source file that you want to import in to the database, and then click Open.
 * 6) Click Advance.
 * 7) In the Code Page list, click Unicode (UTF-8), and then click OK.
 * 8) Click Finish to import the table.

Additional query words: ACC ACC2003 German glyphs garbage junk messed up wrong

Keywords: kbtshoot kbimport kbdatabase kbtable kbprb kbwizard KB899600

-

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

© Microsoft Corporation. All rights reserved.