Hi All,
con <- member <- class <- list()
for(i in 1:5)
{ con[[i]] <-
odbcConnectAccess(paste("C:/Desktop/Data/source",i,".mdb",sep = '')) #read data
from Access files
member[[i]] <- sqlFetch(con[[i]],'member') #get table data from *.mdb
files
observe[[i]] <- sqlFetch(con[[i]],'observe') #get table data from *.mdb
files
}; rm(i)
memberID <- Reduce(function(x, y) merge(x, y, all=T), member, accumulate=F)
#merge members to be unique memberID
observe <- Reduce(function(x, y) merge(x, y, all=T), observe, accumulate=F)
#merge observation data files
attach(member)
params <- glm(Ranking~Andy+Jackie+Kelly+Aaron...) #start calculation from
merged data...
output <- params$coef #get the coef of every single member
detach(member)
result <- sqlSave(con[[i]].....) #save the coef of every single member into
pre-merge source *mdb filesFrom the above coding, I got some data files from
*.mdb files and merge it to calculate, but I was wondering how to save the
result into the table of pre-merge *.mdb files.
Best Regards,
Ryusuke
http://soccer.oksport.cn
_________________________________________________________________
$B:#G/$...@als$7$h$&!*$^$:$O%M%C%HBe$+$i!#(B
[[alternative HTML version deleted]]
______________________________________________
[email protected] 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.
