>I have to update a table in SQL Server each week, and I've been doing it with a manual process until now. Does someone have a sql script for updating fairly large tables?

Look at the Upsizing Wizard code included in Sedna. There is a BulkXMLLoad program included. This is a REALLY FAST way of loading data into SQL. We use it for loading data nightly; stuff that took 45 minutes the usually way take only a couple of minutes (at worst) now. You basically just create your cursor in VFP, call this function with a few parameters and you're good to go.