ACC2000: "Invalid setting in EXCEL Key...," Exporting to dBASE 5

ID: Q201673

The information in this article applies to:
IMPORTANT: This article contains information about editing the registry. Before you edit the registry, make sure you understand how to restore it if a problem occurs. For information about how to do this, view the "Restoring the Registry" Help topic in Regedit.exe or the "Restoring a Registry Key" Help topic in Regedt32.exe.
Advanced: Requires expert coding, interoperability, and multiuser skills.


SYMPTOMS

If you manually change the string "DataCodePage" in the Registry key 


   HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\Xbase
to anything other than "OEM" or "ANSI" and try to export using the dBASE 5 ISAM driver, you receive the following error message:
Invalid setting in EXCEL key of the Engines section of the Windows Registry.


CAUSE

An error is expected when you set the "DataCodePage" string value to something other than "OEM" or "ANSI," which are the only valid options; however, the error message does not refer to the correct Jet ISAM. It should be Xbase instead of Excel.


STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.


MORE INFORMATION

Steps to Reproduce Problem

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. Click Start, and then click Run.


  2. In the Run box, type regedit and then click OK.


  3. In the Registry Editor, expand the following registry key:


    4. HKEY_LOCAL_MACHINE\SoftWare\Microsoft\Jet\4.0\Engines\Xbase
  4. In the right pane, double-click the string value "DataCodePage."


  5. Change the value for string "DataCodePage" to "International" (without the quotation marks) and click OK.


  6. Close the Registry editor.


  7. Open the sample database Northwind.mdb.


  8. Click the Categories table and on the File menu, click Export.


  9. In the Export dialog box, click the arrow in the Save as Type box, and select dBASE 5. Click Save.


Note that you receive the error described in the "Symptoms" section of this article.


REFERENCES

For information about errors you may receive with importing, exporting, or linking text files, please see the following article in the Microsoft Knowledge Base:

Q208206 Error Message Importing/Exporting/Linking Text Files

Additional query words: pra 


Keywords          : kbdta 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbbug

Last Reviewed: May 13, 1999