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.