Hi all: I have created a MS Access table named 'PredictedValues' through the
statement below:
myDB <- odbcConnectAccess("C:/Documents and Settings/Owner/Desktop/Rpond
Farming.mdb",uid="admin",pwd="")
sqlSave(myDB,PredictedValues,rownames=FALSE)
close(myDB)
But if I run the code again with new values I get the message below:
Error in sqlSave(myDB, PredictedValues, rownames = FALSE) :
table ‘PredictedValues’ already exists
and my new records don't get updated.
I was under the impression that 'sqlSave' would copy new data on top of the
existing one or if the table didn't exist it would create one with the new
values. I tried 'sqlUpdate' but my existing 'PredictedValues' didn't update.
What am I doing wrong.
?
Felipe D. Carrillo
Supervisory Fishery Biologist
Department of the Interior
US Fish & Wildlife Service
California, USA
______________________________________________
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.
