title: Efficient way to insert data frame from R to SQL
body: <p>I have a data frame with 10 million rows and 5 columns that I want to insert to an existing sql table. Note that I do not have permission to create a table, I can only insert values into an existing table. I'm currently using RODBCext </p>
  
  <pre><code>query_ch &lt;- "insert into [blah].[dbo].[blahblah] 
                 (col1, col2, col3, col4, col5)
                 values (?,?,?,?,?)"
  
  sqlExecute(channel, query_ch, my_data) 
  </code></pre>
  
  <p>This takes way too long (more than 10 hours). Is there a way accomplish this faster?</p>