Hullo Jim - if you have access to the SQL Server why not [pick one]

1. write a DTS then call it from VFP that will get the data natively IN SQL SERVER into a fox table.
2. use SPT code and make a cursor, then do what ever you want from there.
3. make a remote view ....
4. make an ascii dump of the sql table, then import it into vfp.

any one of those should work for you - personally i prefer #1 when dealing with large data sets, and #2 when dealing with small data sets. I only use #4 when there is some security issue and I have to do offline analysis cause some bonehead dba doesn't understand concept of sql connections.

hth - mondo regards [Bill]
ps - Assuming MS SQL HERE - but #2 works for Oracle, mySql, PostGreSql, FireBird, etc etc.