title: How to insert ADO Recordset into MS Access Table
body: <p><strong>PROBLEM</strong></p>
  
  <p>I want to insert the current recordset row into a MS Access table. I am currently getting this error</p>
  
  <pre><code>Syntax error (missing operator) in query expression 'rs[columnname]'
  </code></pre>
  
  <p><strong>CODE</strong></p>
  
  <p>Here is my current code, I am trying to grab all the columns and insert them into a new table.</p>
  
  <pre><code>DoCmd.RunSQL "INSERT INTO tblSummary_Appl_Usage_score VALUES (rs[Configuration], rs[User Input / Output])"
  </code></pre>
  
  <p>I am not quite sure what i am missing.</p>