R help - Jan 2013 - How to load data from .accdb into R?

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]]