Connecting to DBF Files

Connecting to DBF Files

The SaveToDB add-in allows connecting to DBF files.

The SaveToDB add-in supports the following data providers:

  • Microsoft Access dBASE Driver
  • Microsoft.Jet.OLEDB.4.0 (32-bit only)
  • Microsoft.ACE.OLEDB.12.0
  • Microsoft.ACE.OLEDB.16.0
  • Microsoft OLE DB Provider for Visual FoxPro (VFPOLEDB, 32-bit only)

Here is a sample of the Database Connection Wizard page where you can select the data provider:

Connecting Excel to DBF - Select Provider

In the next step, select a folder (or a file):

Connecting Excel to DBF - Select Folder

Note you can click the Properties button to edit the connection properties.

In the next step, select a DBF file to connect:

Connecting Excel to DBF - Select File

The add-in creates connected tables using Excel native features.

If the driver does not support formats of your DBF files, you can get the error messages like "General ODBC Error" or "External table is not in the expected format."