title: Insert into an access table from SQL using recordset
body: <p>I am using the following code to insert data in an access table from SQL using a recordset. This table is further used for other operations. While this is inserting the data into the table perfectly, the time taken by this huge. Should I use any other method to insert data into the table to reduce the time taken? </p>
  
  <pre><code>Do Until rs.EOF
            DoCmd.RunSQL "INSERT INTO Table (Alpha,Beta,Gamma) VALUES(" &amp; _
            rs.Fields(0).Value &amp; ",'" &amp; rs.Fields(1).Value &amp; "'," &amp; rs.Fields(2).Value _
            &amp; " );"
          rs.MoveNext
  Loop
  </code></pre>