R to access the MS Access
定义DSN(data source name)
control panel ->Administrative Tools->Data Sources(ODBC)->System DSN;
connect Rwith Access
install.packages("RODBC")
libray(RODBC)
channel<-odbcConnect("myAccess")
data<-sqlQuery(channel,paste("select * from my_plan"))