I know how to connect. Doing the inserts by SPT is easy enough: I call a stored procedure on the SQL server and pass parameters to it or I build a string that inserts one row at a time into the target table. What I haven't figured out how to do is to populate a remote view and then bulk update/insert the contents of that view into its source SQL table. BTW thanks for replying. : )


>>I want to push some records into SQL Server from a temporary VFP table. What works? I'm certain it can be done, but I haven't gotten it right yet. Ideas please. : ) > >If you are in VFP, you can use SPT, a view, etc. Do you need help on getting connected to SQL Server?