https://community.blueprism.com/t5/Product-Forum/Oledb-update-query/m-p/48786#M4280 <P>Can someone tell me the update query syntax because I am getting an error that operation is not an updateable query</P><BR /><BR />------------------------------<BR />A S<BR />------------------------------<BR /> Wed, 07 Feb 2024 16:00:00 GMT aanchalm 2024-02-07T16:00:00Z https://community.blueprism.com/t5/Product-Forum/Oledb-update-query/m-p/48786#M4280 <P>Can someone tell me the update query syntax because I am getting an error that operation is not an updateable query</P><BR /><BR />------------------------------<BR />A S<BR />------------------------------<BR /> Wed, 07 Feb 2024 16:00:00 GMT https://community.blueprism.com/t5/Product-Forum/Oledb-update-query/m-p/48786#M4280 aanchalm 2024-02-07T16:00:00Z https://community.blueprism.com/t5/Product-Forum/Oledb-update-query/m-p/48787#M4281 <P>Hi,</P> <P>Can you try the below. Replace the sheet name(Table). column name and value based on your requirement.&nbsp;</P> <P>"UPDATE [SheetName$]&nbsp;<BR />SET [ColumnName] = '"&amp;[ColumnValue]&amp;"' WHERE [ColumnName] = '"&amp;[ColumnValue]&amp;"'</P><BR /><BR />------------------------------<BR />Athiban Mahamathi - <A href="https://www.linkedin.com/in/athiban-mahamathi-544a008b/" target="test_blank">https://www.linkedin.com/in/athiban-mahamathi-544a008b/</A><BR />Technical Consultant,<BR />SimplifyNext PTE LTD,<BR />Singapore<BR />------------------------------<BR /> Thu, 08 Feb 2024 00:58:00 GMT https://community.blueprism.com/t5/Product-Forum/Oledb-update-query/m-p/48787#M4281 Athiban_Mahamathi 2024-02-08T00:58:00Z