Access 2013 - Dbase (.dbf) Table Import option

If you have not had Access 2010 installed previously, you will not have the ACEXBE.DLL file on the computer, thus it is illegal to copy the file from another computer.

Your reg files will only work on a 32-bit computer.  On a 64-bit OS with 32-bit Office, it is in Wow6432Node.

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.

Umm, no it is not illegal. Show me one law that says this is illegal pretty please. It is NOT supported which is different from illegal.

If you create your on .reg files nothing illegal about that.

And no the registry entry is not wrong. It works on about ten different computers. Again it doesn't add a drop down menu in extern data, but it allows you to import through VB .Net or VBA.

-Glenn

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.

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 named ACEXBE.DLL in C:\PROGRA~1\COMMON~1\MICROS~1\OFFICE14

Create 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