Export large .DBF files to .MDB

[Grayfox081877]

Hi Guys
I'm surfing the net and found this site very interesting, and I want to give it a try,I'm planning to create a Wizard using Visual Basic that will export large dbf files to Microsoft Access .mdb, the .DBF files were created using DBU.exe.

my problem now is how on earth can i get a connection to the DBF files.


Hope to hear some answers

 

[Parziale]

This is the code I am using to delete the records from Dbase database. Recode as you need!
------------------------------

Dim dbsdBASE As Database
Dim msdeloption As String
Dim rstAccounts As Recordset
' Open the external dBASE database.
gsscanfilepath = \your path for database gsscanfilename = \your file name Set dbsdBASE = OpenDatabase _
(gsscanfilepath, False, False, _
"dBASE III;&quot
' Create a Recordset object from
' the Accounts table.
' Set rstAccounts = dbsdBASE. _
' OpenRecordset("masinv&quot
Set rstAccounts = dbsdBASE. _
OpenRecordset(yourdatabasename)
msdeloption = MsgBox("Delete previously exported Records?", vbYesNo, "Initialise Scan File?&quot
If msdeloption = vbYes Then
msdeloption = MsgBox("Please confirm to delete!", vbYesNo, "Initialise Scan File!&quot
If msdeloption = vbYes Then
dbsdBASE.Execute " delete * from " & yourdatabasenamevariable & ";"
End If
End If