You can use ODBC. You can create a VFP database and add a Connection to it
using the ODBC data source you have created. Then you can create a VFP
remote view to the table you want and then open the view. There are also
other ways such as SQL Pass-through. You can read more in the VFP Help on
Client/Server and SQL Pass-through.
Will you be reading the data only or are you planning to make
changes/updates to the data?