Hi
I know in Access you can run SELECT queries on external database. You just have to specify type and path. For example:
SELECT * FROM <tablename> IN '' [type; DATABASE=<path>;]
For dBase data source there are values: dBase III, dBase IV;
for Excel - Excel 5.0, Excel 8.0.
What should I write to specify FoxPro type
External Connect
kimkim
It will depend entirely on the version of VFP. You should be able to use the dBase III option for old systems (FoxPro 2.nn) but for VFP 3.0 through 6.0 you would need to use ODBC and create a connection.
For later versions than 6.0 (i.e. 7.0 through 9.0) you will have to use the VFP OLEDB Provider and create a connection (you might be able to use OLEDB on the older versions too, but I am not sure about that)
Big Rob
ODBC (but as far as I know existing ODBC drivers do not support VFP9 databases, you can use with older versions or check latest driver specification).
If you can work with OLEDB in access then use it.