title: Excel VBA ADO UPDATE SQL Table/Record
body: <p>I have managed to update an SQL table and record by using this SQL string</p>
  
  <pre><code>"UPDATE Breach_Test_Key SET [VAL_BREACH_REASON] = 'SOME BREACH REASON'  WHERE  [ID] = 1"
  </code></pre>
  
  <p>Two things I am trying to achieve and that is:</p>
  
  <ol>
  <li>Update two specific columns in the SQL Table, how do I define two
  columns in the SET?</li>
  <li>I also need to update all records that are in a table in Excel back
  into an SQL table (which will all exist in the SQL table).</li>
  </ol>
  
  <p>The ID field will always match as the data is from this table.</p>
  
  <p>Please could someone guide me through the SQL structure for this please?</p>
  
  <p>Thank you @MatteoNNZ for help with part 1, this is the code I am now using to update multiple columns</p>
  
  <pre><code>uSQL = "UPDATE Breach_Test_Key SET [VAL_BREACH_REASON] = 'SOME BREACH REASON1',[VAL_BREACH_DETAIL] = 'SOME BREACH DETAIL1'  WHERE  [ID] = 1"
  </code></pre>
  
  <p>So for part two, I haven't actually got anything sufficient to post but where I have specified a value in the string I would rather it be dynamic to loop through the excel table/column. Any pointers?</p>