access foxpro for dos .dbf file

[Goyette]

I need to access (read/write) a .dbf generated by foxpro for dos. It appears ADO is the way to go, but I'm not sure whether such a file is an ODBC source or what. Anyone out there that can help me?

Thanks,

Don Goyette

[rcallan]

The ODBC drivers for Foxpro files are normally installed automatically with Windows/NT or VB etc. So you can set up a datasource quite easily to access these files. Alternatively you could use a "dsnless" connection by passing a connection string with ADO specifying the name of the ODBC driver to use. However, you will probably have to get the Visual Foxpro (VFPODBC.DLL) driver from somewhere as the Foxpro (.dbf) driver is no longer supported.