Update query

Hi ,

Did any one tried update query in Oledb-execute action? Please reply here. I am getting error while using it.

Iam trying to update a column in excel using oledb. Pls help

Thanks
 
Hi Sachin,

Thank u very much , it works with text .
But here in query I have to update cells with vlook up formula . It’s throwing error with that formula.
Does this works even with vlook formula?

Thanks
 

Anubhav247

New Member
Hi Sachin,

Thank u very much , it works with text .
But here in query I have to update cells with vlook up formula . It’s throwing error with that formula.
Does this works even with vlook formula?

Thanks
Can you please describe the problem with an example? I do think i came across such a scenario
 
Top