How do you open a Foxpro *.dbf database file using ADO.
Simple open please.
Printable View
How do you open a Foxpro *.dbf database file using ADO.
Simple open please.
use ODBC?
Here's the connection string that you use.
ADOConnectionObject.ConnectionString = "Driver={Microsoft Visual FoxPro Driver};UID=;PWD=;SourceDB=<path>;SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Nu ll=Yes;Deleted=Yes;"
The <path> tag refers to the folder where the .dbf file is and not the filename of the .dbf file. When opening the recordset object use the .dbf's name.