The same way you would from a local view or table:

USE MyView

Select MyTable
Append from MyView

Once you USE it it's just more VFP data.

Barbara

>Ok, I've successfully connected to our remote sql server and have created a remote view through VFP. Now, how do I insert that remote view data into a local VFP table? Thanks!