Using ADO to open a DBF file
Posted on 2000-04-03
I'm having difficulty opening a dBASE data file using ADO. I need to be able to append records to this file from my VB 6 app. I tried the following code which was based on information I got from the Microsoft web site:
dim con As New ADODB.Connection
con.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\rssc\Emcr.dbf; Extended Properties=dBASE III;"
The error message I get is ...
'c:\rssc\Emcr.dbf' is not a valid path. Make sure that the path name ...(blah, blah, blah)...
I've verified that this is the correct path to the filename and this file is a valid dBASE file (I imported it successfully into an Access table). I don't know for sure whether this DBF file came from dBASE III, IV, V or perhaps FoxPro (how can I tell?) Also, how can I tell if my OLEDB provider version info is correct? Any help will be greatly appreciated.