HI, All,
I have three dabases:
analysis_tool.accdb is linked into sellout.mdb and audit.accdb.
whenever I use this database, I need to firstly open "analysis_tool", then
press "External data"->"Linked Table Manager" to link the other two databases.
Now I want to load the data from those database into R, I know I can use the
following queries to load data from Analysis_tool .accdb into R:
library(RODBC)
testdb <- file.path("C:/Users/ty/Documents/Analysis_tool.accdb")
channel <- odbcConnectAccess2007(testdb)
Data <- sqlFetch(channel,"Table1")
how do I load data from all those linked databases but not only
Analysis_tool.accdb?
Kind regards,
Tammy
[[alternative HTML version deleted]]
______________________________________________
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.
