title: Getting data from dataframe to MS-access DB Target Tables using R
body: <p>I have created Data frames in R. I have connected to access DB using below code.
  I am able to extract all data from access db to R. </p>
  
  <p>I have 3 tables in Access like A , B , C</p>
  
  <p>Created same data frames in R like A, B, C</p>
  
  <p>How to move the R data frames of A, B, C from R to Access DB Target Tables A,B,C?</p>
  
  <p>Using R coding in R studio.?</p>
  
  <p>Please help on this, this is important task for me.</p>
  
  <pre><code>con &lt;- odbcDriverConnect("Driver={Microsoft Access Driver (*.mdb, *.accdb)};
                            DBQ=C:/Users/chintan/Desktop/Published.accdb")
  
  # Get data
  Pub &lt;- sqlQuery(con, "select * from certifications
                        Where [Business Group]='EG'
                        AND FY='FY15'")
  </code></pre>