Chris,

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

VFP's Remote View provides an easily reproducible and accessible mechanism to do this. Even with no experience a developer can create an updateable RV against a SQL Server table in as little as a minute. After that you can simply USE the Remote View NODATA (use the NODATA because unless you specify a filter in the RV, it will pull across the whole SQL table!)

Do the fields in SQL Server match or approximately match the dbf fields?

If so, create an updateable VFP Remote View and simply append the dbf whenever you need to.

If the match is not perfect, either get the dbf into a cursor/dbf that does match the SQL table and then append, or insert a set of expressions into the RV cursor.

Watch out for datetime fields where VFP allows blank values but SQL Server does not. It's easiest to transfer a NULL if that happens.