Microsoft KB Archive/163280

= ACC97: Error Message Importing/Exporting/Linking Text Files =

Article ID: 163280

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q163280



IMPORTANT: This article contains information about editing the registry. Before you edit the registry, you should first make a backup copy of the registry files (System.dat and User.dat). Both are hidden files in the Windows folder.

Advanced: Requires expert coding, interoperability, and multiuser skills.



SYMPTOMS
When you use the Export Text Wizard to import, export, or link a text file you may receive the following error message:

Invalid setting in the Excel Key of the engines section of the Windows Registry



RESOLUTION
Use the Registry Editor program, Regedit.exe, to modify a Windows Registry key.

WARNING: Using Registry Editor incorrectly can cause serious problems that may require you to reinstall Windows 95. Microsoft cannot guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk.

For information about how to edit the registry, view the Changing Keys And Values Help topic in Registry Editor (Regedit.exe). Note that you should make a backup copy of the registry files (System.dat and User.dat) before you edit the registry.  Start the Registry Editor program, Regedit.exe (in Microsoft Windows 95) or Regedt32.exe (in Microsoft Windows NT).  Search for the following key:      HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\3.5\Engines\Text   Under the Format Key, you will find the following value:      "DELIMITED"  Change the value of the Format parameter to CSVDelimited. This is a string value. It does not have parentheses. Under the Extension Key, make sure you see the following value:

"txt,csv,tab,asc"

NOTE: This string has no spaces in it.</li> Close the Registry Editor program.</li></ol>

Additional query words: attach txt

Keywords: kberrmsg kbprb KB163280

-

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

© Microsoft Corporation. All rights reserved.