Cetin,

You are a prince!
Thank's a lot and a prosperous and happy new year to you and yours.

BR

Peter

>>>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
>>
>>Cetin,
>>
>>I'm sure you would, and so would I if I only knew what you are talking about :-))
>>
>>I'm behind on Visual Studio - Common Language Runtime (right?) procedure fit's in how and where?
>
>You write your procedure using C# or VB (and thus can use OleDbConnection and such if you mark it unsafe) and add that assembly to a database. Once added it is part of the database and you can use that as if it were native SQL server function, SP etc. In the help check Create assembly ... I will try to send a sample when I get to ny work computer.
>Cetin