Tech support scams are an industry-wide issue where scammers trick you into paying for unnecessary technical support services. You can help protect yourself from scammers by verifying that the contact is a Microsoft Agent or Microsoft Employee and that the phone number is an official Microsoft global customer service number. Hello, I am setting up a new Win 10 laptop, and noticed it does not have the Microsoft dBase driver (.dbf) under ODBC User Data Sources. I need it to open an older application. DBASE Files.; 2 minutes to read; In this article. ODBC Desktop Database Drivers version 4.0 includes the following ISAM files for the Microsoft dBASE driver. As far as I know, DBF files are no longer supported in Office 2013. But DBF 3, DBF 4 dBase III and IV. Users can open these files formats in Excel 2013, but, users can't save an Excel 2013 file to dBase format. It seems that you can view DBF files but not edit them. How about import DBF file to Access as a workaround?
Microsoft dBase driver (*.dbf) connection string
Microsoft dBase driver allows connection to dBase databases (DBF and DBT files) over ODBC.
- DBF files store 8-bit characters thus Unicode characters are not supported
- This driver is preinstalled in modern versions of Windows desktop
Driver
CollatingSequence
Collating (sort) order not a code page. Supported values are:
- ASCII – sort as ASCII text, this is default value
- International – international sort order (Western Europe)
- Norwegian-Danish – as is says this is Norwegian-Danish sort order
- Swedish-Finnish – as it says Swedish-Finnish sort order
Microsoft Dbase Driver Download
DBQ
This mandatory parameter should point to folder containing database files (*.dbf etc).
Microsoft Dbase Driver 64 Bit Download
Dot character DBQ=. means current folder.
Deleted
Microsoft Dbase Driver
This optional values specifies should the driver display deleted records. dBase does not physical delete records upon DELETE query just mark them as deleted so deleted records could be read.
- 0 – hide deleted records
- 1 – display deleted records as usual ones
DriverId
A number specifying driver type.
- 21 – dBASE III
- 277 – dBASE IV
- 533 – dBASE 5.0, this is default value
ReadOnly
Optional boolean value to specify access type.
- 0 – read/write access, this is default value
- 1 – read only access, may be useful as a protection if the connection is not intended to modify data
When trying to make any changes on connection with ReadOnly=1 error will be reported.
Exclusive
This optional boolean value allows to take exclusive access to the database.
- 0 – non-exclusive access, other programs will be allowed to open the database, this is default value
- 1 – exclusive access, other programs will not be allowed to open the database
Microsoft dBase driver (*.dbf) examples
Connect to current folder for read-only access:
Connect to C:ProgramDatabase with exclusive read-write access: