export .mdb to .dbf

[edric trinidad]

give some code on how to search, add,edit,delete if my extension name is .dbf i'am useing ADO

[Iouri]

You can do it the same way as it is an mdb file. The difference will be only in your connection string.

oConn.Open "Driver={Microsoft dBASE Driver (*.dbf)};" & _
"DriverID=277;" & _
"Dbq=\somepath;"

Note: Specify the filename in the SQL statement. For example:
oRs.Open "Select * From user.dbf", oConn, , ,adCmdText

Note: MDAC 2.1 (or greater) requires the Borland Database Engine (BDE) to update dBase DBF files.
(Q238431).



Iouri Boutchkine
[email protected]

[Cyrus]

oConn.Open "Driver={Microsoft dBASE Driver (*.dbf)};" & _
"DriverID=277;" & _
"Dbq=\somepath;"

Note: Specify the filename in the SQL statement. For example:
oRs.Open "Select * From user.dbf", oConn, , ,adCmdText

Note: MDAC 2.1 (or greater) requires the Borland Database Engine (BDE) to update dBase DBF files.
(Q238431).

I'tried to use this ..but failed..what am i missing

thanks

cyrus