Hey Xin this is a piece I copied from my blog. library(RODBC) mdbConnect<-odbcConnectAccess("C:\\temp\\demo.mdb") sqlTables(mdbConnect) demo<-sqlFetch(mdbConnect, "tblDemo") odbcClose(mdbConnect) rm(demo)
On Mon, Jul 19, 2010 at 12:05 AM, Xin Ge <xingemaill...@gmail.com> wrote: > Hi All, > > Can anyone please suggest me from where should I start to learn about 'how > to connect to access db' ? > > How if someone has some written code and I can go over that to understand > and make necessary changes... any help would be highly appreciated, > > -- > Xin Ge. > > [[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. > -- ============================== WenSui Liu wens...@paypal.com statcompute.spaces.live.com ============================== ______________________________________________ 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.