>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!)
>
As I said to Chris, there are multiple ways to do this. Remote Views would likely work, though it wouldn't be high on the list of recommendations.
If he's going to invest time in a solution, SSIS is a better investment of time. It can handle this situation, as well as many others.