[R] Update dataframe to Access without delete values

cindy.dol cindy.dolomieu at insa-lyon.fr
Mon Jun 18 10:30:31 CEST 2012


Hi! 
I created a table named "TEST2" in my base Access named "CINDY". 
My columns are : "A" (numeric), "B" (character), "C" (numeric) 
There are values in this table. 

In R, I created a data.frame fr: 
fr <- data.frame(A = c(1,2,3),B = c("c","d","u"), C=c(4,5,6)) 
I would like export this data.frame in my table TEST2 without delete the
values which are inside. 

I tried : 
sqlUpdate(CINDY, fr, 'TEST2',index=colnames(fr)) 

But it doesn't work... 

Can you help me please? 
Thanks 

--
View this message in context: http://r.789695.n4.nabble.com/Update-dataframe-to-Access-without-delete-values-tp4633673.html
Sent from the R help mailing list archive at Nabble.com.



More information about the R-help mailing list