After updating a large temporary DBF with data, what is the fastest way of updating the corresponding SQL Server table without having to SCAN through the DBF and issuing individual UPDATE commands.
Note: I have matching Primary keys on the DBF and SQL Server tables.