Create an ADODB Connection to a dBASE 5 .dbf file

[Guest]

Hi

My Access 2003 book says I can use the OLE DB Provider for Microsoft Jet to
connect to a dBASE database. I have tried the following but get
"Unrecognised database format" error message

cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source
=C:\database\CLIENTS.DBF;"

What have I left out?

regards

Sara

 

[Brendan Reynolds]

Include the folder name only in the data source, no file name. dBase uses
the folder as the database container, and stores each table in a separate
file within that folder. Think of the folder as the equivalent to the MDB,
and the *.DBF files within that folder as the equivalent of the tables in
the MDB.