How can I export r data frames to Microsoft Access tables?
<p>I am currently using <code>sqlSave</code> to export data frame from r into a Microsoft Access database. Are there any other faster or more efficient ways to export r data frames to Microsoft Access tables?</p>

<pre><code>   library(parallel)
   num_cores &lt;- detectCores()
   cl &lt;- makeCluster(num_cores)
   clusterEvalQ(cl,library(evir))
   set.seed(0)
   system.time(
      x1 &lt;- parLapply(cl, 1:100000,
      function(i) {
          n1 &lt;- rpois(1,4)
          n2&lt;-  rpois(1,7)
      list(data.frame(a=rexp(n1, rate=0.1),a1=rexp(n1, rate=0.6)), 
         data.frame(b=rexp(n2, rate=0.7),b1=rexp(n2, rate=0.6)))

   }
  )
 )

  y1 &lt;- lapply(x1, function(x) x[[1]][["a"]])

  lengths&lt;-function(x) vapply(x,length,1L)

 Create.Matrix&lt;- function(l, s){
   if(is.numeric(l) &amp;&amp; length(l) == 0){
      c(0, rep(0, s - 1))
   }else{
      c(l, rep(0, s - length(l)))
  }
 }
 xl &lt;- data.frame(mapply(Create.Matrix,y1, max(lengths(y1))))  
 db &lt;- "Z:/s.accdb"
 con2 &lt;- odbcConnectAccess2007(db)
 sqlSave(con2,xl,"xl",rownames=FALSE,safer=FALSE,fast = TRUE)
</code></pre>