Here's how we do it using an OleDB provider for VFP:

using System.Data.OleDB; private void FillDataSet() { OleDbConnection foxConn = new OleDbConnection( "Provider=VFPOLEDB.1;Data Source=C:\\DataDirectory"); OleDbCommand foxCommand = new OleDbCommand(); OleDbDataAdapter foxDA = new OleDbDataAdapter(); DataSet foxData = new DataSet(); foxCommand.Connection = foxConn; foxCommand.CommandType = CommandType.Text; foxCommand.CommandText = "SELECT * FROM myTable"; foxDA.SelectCommand = foxCommand; foxDA.Fill(foxData, "MyTable"); }