title: Execute SQL update statement in Excel
body: <p>I'm trying to execute this code but I get an error: "an updatable query is required for the operation".</p>
  
  <p>can someone help me please?</p>
  
  <pre><code>Dim con As ADODB.Connection
  Dim rs As ADODB.Recordset
  
  Set con = New ADODB.Connection
  
  con.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" &amp; ThisWorkbook.FullName &amp; ";Extended Properties=""Excel 12.0 xml;HDR=YES;IMEX=1;Readonly=False"";"
  
  Set rs = New ADODB.Recordset
  Set rs = con.Execute("UPDATE [Tipo record 010$] SET tipo_record = 'NICK' WHERE numero_operazione = '999189944458'")
  
  Set rs = Nothing
  Set con = Nothing
  </code></pre>
  
  <p>an updatable query is required for the operation</p>