Select from excel with replace function .net 2
Hi all,
I need to select replace(X,oldvalue,newvalue) from tbl.
I get error message that replace function is not recognize.
I use oledbcommand.
with .net 2.
how can I use replace,substring function.
Thanks.