>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?
Peter Pirker
Whosoever shall not fall by the sword or by famine, shall fall by pestilence, so why bother shaving?
(Woody Allen)