Microsoft 365 and Office | Access | For home | Windows
A family of Microsoft relational database management systems designed for ease of use.
Access 2013 - Dbase (.dbf) Table Import option
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
I need to be able to import read/write Dbase dbf tables - yes they are still around so why has the standard option that was in Access 2010 gone?
I have seen mention of ISAM, which is gobbledegook to me. So please a simple answer - what do I need to install or change and how do I do it?
Microsoft 365 and Office | Access | For home | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 51%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
158 additional answers
Sort by: Most helpful
-
Anonymous
2014-10-08T17:49:54+00:00 What you are suggesting is really not legal to do...you are registering a Access 2010 feature that was removed from Access 2013 and your suggested registry entry is incorrect.
If you need dBASE support, the only legal method is to downgrade to Office 2010.
-
Anonymous
2014-10-08T16:49:48+00:00 While you cannot use the external data tab. You can in VB .Net 2013 Express (And VBA I believe)
use this code. You will need to add to your registry the dbase information.
`Dim AccessConn As New System.Data.OleDb.OleDbConnection( _ "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\S\Job.mdb")
' Import DBF File AccessConn.Open() Dim AccessCommand As New System.Data.OleDb.OleDbCommand( _ "SELECT * INTO [Job] FROM [dBase III;DATABASE=D:\S].[JobX]", AccessConn) AccessCommand.ExecuteNonQuery() AccessConn.Close() `
You can create a new text file for the registry files.You also may need a .dll namedACEXBE.DLL in C:\PROGRA~1\COMMON~1\MICROS~1\OFFICE14Create a text file called, dBASE-3.0.reg copy the lines below into it. The save and close. Click on file. This will add the dbase to the registry
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\15.0\Access Connectivity Engine\ISAM Formats\dBASE III]
"Engine"="Xbase"
"ExportFilter"="dBASE III (*.dbf)"
"ImportFilter"="dBASE III (*.dbf)"
"CanLink"=hex:01
"OneTablePerFile"=hex:01
"IsamType"=dword:00000000
"IndexDialog"=hex:00
"CreateDBOnExport"=hex:00
"SupportsLongNames"=hex:01
Here are other dbase files:
dBASE-4.0.reg
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\15.0\Access Connectivity Engine\ISAM Formats\dBASE IV]
"Engine"="Xbase"
"ExportFilter"="dBASE IV (*.dbf)"
"ImportFilter"="dBASE IV (*.dbf)"
"CanLink"=hex:01
"OneTablePerFile"=hex:01
"IsamType"=dword:00000000
"IndexDialog"=hex:00
"CreateDBOnExport"=hex:00
"SupportsLongNames"=hex:01
dBASE-5.0.reg
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\15.0\Access Connectivity Engine\ISAM Formats\dBASE 5.0]
"Engine"="Xbase"
"ExportFilter"="dBASE 5 (*.dbf)"
"ImportFilter"="dBASE 5 (*.dbf)"
"CanLink"=hex:01
"OneTablePerFile"=hex:01
"IsamType"=dword:00000000
"IndexDialog"=hex:00
"CreateDBOnExport"=hex:00
"SupportsLongNames"=hex:01
xBase.reg
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\15.0\Access Connectivity Engine\Engines\Xbase]
"win32"="C:\PROGRA~1\COMMON~1\MICROS~1\OFFICE14\ACEXBE.DLL"
"DbcsStr"=hex:01
"Mark"=dword:00000000
"Date"="MDY"
"Exact"=hex:00
"Deleted"=hex:01
"Century"=hex:00
"CollatingSequence"="Ascii"
"DataCodePage"="OEM"
"NetworkAccess"=hex:01
"PageTimeout"=dword:00000258
-
Anonymous
2014-09-23T06:54:38+00:00 For us, the only option seemed: DOWNGRADING. Exit Access 2013, welcome back Access 2007. But I do hope Microsoft comes to its senses and restores this functionality soon...
-
Anonymous
2014-09-22T19:17:53+00:00 BTW, since I do not believe that Microsoft will be adding this functionality back into Access anytime soon, can I ask those that are still subscribed to this thread, what solution they ended up adopting?