> Andy,
> How could I use ODBC with VFP database and dbf? I use VFP as front end,VFP database and dbf as back end. How could I use ODBC to link the two? What files should I install on my PC to use ODBC? Could you please teach me in details?
> Regards,
> Nilson

First, to connect to a VFP data source you need the VFP ODBC driver. This will work well with VFP Tables up to and including Version 6.0, but will not support new database features (like auto-incrementing fields). To set up a connection, first download the ODBC driver from Microsoft and set up the driver (you can find details at
https://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/vfpodbcodbcvisualfoxprosetupdialogbox.asp)

Then go to
http://www.connectionstrings.com/
to get examples of how to establish a connection

Once you have a connection, use SQLEXEC() and the connection handle to query the data.

Regards
Andy Kramek
Microsoft MVP (Visual FoxPro)
Tightline Computers Inc, Akron Ohio, USA