Hi all,
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