title: Access 2013 Fill table with a Recordset
body: <p>I want to execute a Select SQL-Command and fill my table with the information from the table. </p>
  
  <p>This is my current progress:</p>
  
  <pre><code>Set rs = CurrentDb.OpenRecordset("SELECT * FROM myOrder")
  </code></pre>
  
  <p>I got the information in my Recordset but I don't know how to put this into my table.
  Please no bad comments, because I dont have many experience with VBA + Access so hope you guys can help me.</p>
  
  <p>My table</p>
  
  <pre><code>|        myOrder                            |
  |-------------------------------------------|
  | aID | aAsset |  aOrdernumber | aSN        |
  |  1  |  1235  |    12234156   | ASFF45432S |
  |  2  |  1236  |    12541221   | WSABBS211Z |
  </code></pre>
  
  <p>This is my table and I want to execute the sql above to put the result of the recordset into my tableview.</p>