Follow

3127

When I try to export a Termbase to Excel format, I get this error message, and the export doesn't finish, or it finishes but little or no data was exported:

Error 3127
The INSERT INTO statement contains the following unknown field name: 'F1'. Make sure you have typed the name correctly, and the operation again.

This happens because a specific value in the Registry is missing, without which the Jet Database Engine (which Déjà Vu uses to handle its databases) cannot interact correctly with Excel.

You can download and run a script that will add the value for you. To do so:

  1. Download the script.
  2. Unzip the file you download.
  3. Run the unzipped file as Administrator.
  4. When the script finishes running, press any key to close the window.

After that, exporting a Termbase to Excel should no longer give this error message.

Alternatively, you can edit the registry yourself to add the necessary value. To do so:

  1. Start the Registry Editor.
  2. Find the key where the missing information should be stored:
    1. For 64 bit Windows: HKEY_LOCAL_MACHINE\Software\Wow6432Node\Microsoft\Jet\4.0\Engines\Excel
    2. For 32 bit Windows: HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\Excel
  3. Access the menu option Edit>New>Binary Value.
  4. A new DWORD will be created, and you will be able to name it. Name it FirstRowHasNames.
  5. Once it has been created, access the menu option Edit>Modify.
  6. Enter the number 0, and then click on OK. When you enter the value 0, you may see 00 appear instead. This is normal.
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk