ABRI ARQUIVO DBASE
Ola galer, alguem sabe como é que eu faço para abrir um arquivo dbase.
Ex:
Dim ConexaoDBF As ADODB.Connection
Dim rsEdifDBF As ADODB.Recordset
Set ConexaoDBF = New ADODB.Connection
ConexaoDBF.Open "provider=Microsoft.Jet.OLEDB.4.0;" & _
"data source=" & DirMes & ";" & _
"extended properties=""dbase iii;"";"
Set rsEdifDBF = New ADODB.Recordset
rsEdifDBF.CursorLocation = adUseClient
rsEdifDBF.Open "SELECT * FROM [CADED#DBF] ORDER BY CODED", ConexaoDBF, adOpenDynamic, adLockOptimistic
Abraços,
Dim ConexaoDBF As ADODB.Connection
Dim rsEdifDBF As ADODB.Recordset
Set ConexaoDBF = New ADODB.Connection
ConexaoDBF.Open "provider=Microsoft.Jet.OLEDB.4.0;" & _
"data source=" & DirMes & ";" & _
"extended properties=""dbase iii;"";"
Set rsEdifDBF = New ADODB.Recordset
rsEdifDBF.CursorLocation = adUseClient
rsEdifDBF.Open "SELECT * FROM [CADED#DBF] ORDER BY CODED", ConexaoDBF, adOpenDynamic, adLockOptimistic
Abraços,
Tópico encerrado , respostas não são mais permitidas