>I thought about using a remote view but I wanted to explore some other options. My main concern is speed of the update and network traffic. The first choice would be to schedule a DTS package job to run in the middle of the night. I would like to have the user be able to run this job either directly or by a stored procedure (if possible?) Would it be better to use a remote view with a possible record set of several thousands?

It is certainly possible with a stored procedure and could easily be accomplished in VFP. You just use SQLEXEC() to call the SP and pass the field values in the table as parameters. Now, that I have done before.