Displaying 1 result from an estimated 1 matches for "acceschannel".
2010 Nov 25
1
RODBC
...I am running the RODBC examples form the help guide. I am trying to
UPDATE a table in an Access data base but I am having an error.
library(RODBC)
library(termstrc)
path = getwd()
setwd(getwd())
dbName = "data.mdb"
pathdbname = paste(path,"/",dbName,sep="")
accesChannel = odbcConnectAccess(pathdbname, uid = "", pwd = "")
sqlSave(accesChannel, USArrests, rownames = "state", addPK=TRUE)
sqlFetch(accesChannel , "USArrests", rownames = "state") # get the lot
foo <- cbind(state=row.names(USArrests), USArrests)[1:3,...