Here is an example of an OleDB connection to a .DBF file
(In this case it is FoxPro):
Imports System.Data.OleDb
Module mdlPublic
Public cn
'* Opens a connection to the FoxPro table
Public Sub subOpen_FD_Database()
With cn
If .State = ConnectionState.Open Then .Close()
.ConnectionString = "Provider=VFPOLEDB.1;Data Source=D:\FOXDENT\DATA;Collating Sequence=MACHINE"
.Open()
End With
'* The above example will open all of the .dbf files
'* in D:\FOXDENT as a database. Replace the directory
'* name above with the directory where your files are
'* located.
End Sub
End Module
Best Regards,
Earl Francis