Check book Client-Server Applications with Visual FoxPro and SQL Server 7.0 from http://www.hentzenwerke.com/catalogpricelists/csvfp.htm

>i am about to embark on my first project involving VFP6 and SQL Server. what i need to do is take the data within the SQL Server, present it for confirmation and upload it into an existing Foxpro database. i will also need to make sure that the SQL Server masterlists are current and update them from the foxpro tables as necessary.
>in light of this, what is the best way to connect to the data? do i go through ADO? views? or some other method? any advice would be greately appreciated.
>many thanks,
>Jordan