ACC2000: Error Message Importing/Exporting/Linking Text Files

• Microsoft Access 2000

SYMPTOMS

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

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 your operating system. 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) or the "Add and Delete Information in the Registry" and "Edit Registry Data" Help topics in Regedt32.exe. Note that you should back up the registry before you edit it. If you are running Windows NT, you should also update your Emergency Repair Disk (ERD).

1. To start the Registry Editor program, click Start, and then click Run. In the Open box, type Regedit.exe (in Microsoft Windows 95) or Regedt32.exe (in Microsoft Windows NT). Click OK.



2. In the Registry Editor, expand the following key:




HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4\Engines\Text

3. Under the Format Key, you will find the following value:




   "DELIMITED()" 

4. Change the value of the Format parameter to the string CSVDelimited.



5. Close the Registry Editor program.

Additional query words: attach txt

Keywords : kberrmsg kbdta IsmTxtd IsmTxtfx
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb