Oledb update query

[aanchalm]

Can someone tell me the update query syntax because I am getting an error that operation is not an updateable query

------------------------------
A S
------------------------------

[Athiban_Mahamathi]

Hi,

Can you try the below. Replace the sheet name(Table). column name and value based on your requirement. 

"UPDATE [SheetName$] 
SET [ColumnName] = '"&[ColumnValue]&"' WHERE [ColumnName] = '"&[ColumnValue]&"'

------------------------------
Athiban Mahamathi - https://www.linkedin.com/in/athiban-mahamathi-544a008b/
Technical Consultant,
SimplifyNext PTE LTD,
Singapore
------------------------------