Hello, I have an issue with SqlUpdate and perhaps you can help me. I have created a table with sqlSave. My table on Access is "PRT". My dataframe on R : RESULTS. My channel : C2. sqlSave(C2, RESULTS, tablename = "PRT",rownames=FALSE, safer = FALSE) And it works.
Now I would like to update it, to keep the old values and add new values. I tried : sqlUpdate(C2, RESULTS, tablename="PRT", append=TRUE) But it doesn't work, the error message is :"cannot update ‘PRT’ without unique column" Do you know how I can do it? -- View this message in context: http://r.789695.n4.nabble.com/sqlSave-tp892040p4634881.html Sent from the R help mailing list archive at Nabble.com. ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
