>Thanks for the help and advice, however I will need to pull all of the data eventually as I will be moving the data from one database to another when completed. I just wanted to allow the user to view sample data to aid in deciding how to transfer the data. The new system has fields with different names...
>
>On a slightly different note: Is it possible to do use tableupdate and table revert commands with sql passthrough... I cannot set up remote views on the data as, it doesn't work properly, whereas sql passthrough gets the data...
>
>My experience with sql passthrough has always been of the read only variety and I have never had to update data before..
>
>Thanks for all of your help... I'll go read that FAQ now...

Yes,

You can make SPT cursor updatable. Vlad has a FAQ on that too. However transfering millions records through VFP may not be the best solution. What kind of RDBMS you transfer data between?