Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How update data in dBASE?
- Thread starter VNDN
- Start date
- Thread starter
- #2
- Thread starter
- #4
[tt]
Dim Cn As ADODB.Connection
Dim Cm As ADODB.Command
Dim Rs As ADODB.Recordset
Dim DSNName As String, ThePath As String
'DSNName = ODBC DSN
'ThePath = Path to the table you want to open
Set Cn = New ADODB.Connection
Cn.Open "DSN=" & DSNName & ";DriverId=533;FIL=dBase 5.0;MaxBufferSize=2048;PageTimeout=5;source= " & ThePath
[/tt]
Remember this uses the foxpro driver for the ODBC DSN with a configuration of a free table directory. (That way you can switch between drives/folder etc.)
Good Luck
- Status
Similar threads
