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
--sb--