export .mdb to .dbf

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

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]

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