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.Mva

Now I need to update the values I1.WinterTires1 (the dbf) with I2.WinterTires2 (Sql server)

The closest I get returns:

OLE/DB Provider 'VFPOLEDB' IRowsetChange::QueryInterface returned 0x80004002: IRowsetChange]

Help is much appreciated.

I've tried Google, BTW

Regards