As usual, there are many ways to accomplich a task, when it comes to programming. I would suggest you look into ADO,(
www.microsoft.com)for white papers, and look at the Wrox book on ADO 2.0. There are several good Wrox books on the subject of ADO. Ken Levy has a prg that converts ADO recordsets to VFP data. Ken's approach is cool, but you take a hit due to the conversion process used.
I went a different route, using a 2nd tier DLL (written in VFP 6.0), that handles all ADO functions, and can use a (forgive me) VB, Power Builder or VFP front end.
For my VFP front end, I create the ADO object, create a cursor, and APPEND the ADO recordset to the cursor. It is very fast, and easy to do.
Tom