Access 2013 DBF Files import help

I know MS removed the DBF import export, but hopefully someone knows of a workaround.

I use Access to import/export dbf files as needed for our presort software. The code is:
DoCmd.TransferDatabase acImport, "dBASE IV", "D:\S\Work\123", acTable, "123.DBF", "APNDIN"

And I know how in VB 2010 to import DBF files without automation as shown below.

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()

My question is how can I do this in my Access Module? Is there any addons that will do this? The importing and exporting process uses a field in a table to determain the table name, as that changes with each job.

0 answers