Sem usar ODBC(é para DBASEIV mas presumo que funciona para DBASEIII):
Function OpenDBFConn(Path)
Dim Conn As Connection
Set Conn = CreateObject("ADODB.Connection")
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Path & ";" & _
"Extended Properties=""DBASE IV;"";"
Set OpenDBFConn = Conn
End Function
Private Sub Command1_Click()
'Abir Conexão para ficheiros DBF em C:[Nome do Directorio]
Dim DBConn As Connection
Set DBConn = OpenDBFConn("C: estes")
'Criar um novo ficheiro DBF chamado Persons.DBF
DBConn.Execute "Create Table Persons (Name char(50), City char(50), Phone char(20), Zip decimal(5))"
End Sub
Private Sub Command2_Click()
'Inserir alguns registos na Tabela Persons
Dim DBConn As Connection
Set DBConn = OpenDBFConn("C: estes")
DBConn.Execute "Insert into Persons Values('Alex P. Nor', 'Mexico','458962146','14589')"
End Sub
Private Sub Command3_Click()
'Abir recordset da Tabela Persons
Dim DBConn As Connection
Set DBConn = OpenDBFConn("C: estes")
Dim Persons As Recordset
Set Persons = DBConn.Execute("Select * from [Persons#DBF]")
End Sub