SELECT I1.* ,I2.WinterTires2 FROM OPENROWSET('VFPOLEDB', '\\SomeMachine\SomeDriveTable1.dbf'; ''; '', 'SELECT Cast(Mva AS Integer) AS Mva, WinterTires1 FROM Table1') I1 INNER JOIN [dbo].[Table2] AS I2 ON I1.Mva = I2.MvaNow I need to update the values I1.WinterTires1 (the dbf) with I2.WinterTires2 (Sql server)