
ADO ConnectionString for dBASE IV
With thanks to Carl Prothman, I've used the following:
Set cn = New ADODB.Connection
cn.Open "Driver={Microsoft dBASE DRIVER (*.dbf)};DriverID=277;" & _
"Dbq=d:\vb_apps\parse_addr_num;"
- Tom
Quote:
> Does anyone have an example of an ADO connection string for dBase IV
that
> uses OLE DB? Here's an example of what I am trying, but which does
not
> work:
> With mcnTest
> .ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
> "Data Source=\\myserver\myshare\mydata.dbf;" & _
> "Extended Properties=dBase IV;"
> .Open
> End With
> Thanks for your help,
> Todd A. Blanchard