>
>If instead of using SQLEXEC I had created a remote a view -- and then done a tableupdate(.t.) VFP would write an update command behind the scenes. Would this be a single update? or a series of updates inside a loop?
VFP will create multiple updates, one for each row, and submit them to the server.
>In short is there away around all this loopiness? Or is SQL inside a loop simply the price I pay for putting processing on the client end?
SQL Server 7.0 added the BULK INSERT which was designed to be BCP from within TSQL. Maybe you could have VFP create a import file on the SQL Server and then execute a stored procedure which would use the BULK INSERT statement to pull it into a temp. table.
-Mike