It may not be possible because VFP OLE DB provider supports only read (query data) access when used in a linked server/OPENROWSET.

>

>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