I set cursor prop for ALL files and it worked.

AFter Insert I would select the SQL table and then issue a Tableupdate() then close database all

then open the remote SQL view and there is only one record in the SQL table but there was 150 in the DBf that was inserted from.