>

>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

Peter,
Update command in openrowset() errors but works despite the error. I would however use a CLR procedure if I had to update from within SQL server.

select * from openrowset('VFPOLEDB', 
 'c:\myPath\testdata.dbc';'';'',
  'update customer set contact="Ana TrujilloXX" where cust_id = "ANATR"')

Cetin