Looking for a little bit of best practices, and a little bit of how to.

I need to update a SQL Server table with values from a VFP table.

Should I upload the VFP table to a temporary SQL cursor and SQLEXEC the update statement? How would upload the cursor and remove it when done?

Or should I download the SQL table to a VFP cursor,run the UPDATE statement in VFP, and post the results back to SQL? How would I post the updates back to SQL?

I know how to do this by SCANning the VFP table and updating a single record at a time, but I would prefer to avoid that overhead.

Chris.