[R] Connecting to MS Access database

Wensui Liu liuwensui at gmail.com
Mon Jul 19 06:10:46 CEST 2010


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 <xingemaillist at 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 at 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
wensliu at paypal.com
statcompute.spaces.live.com
==============================



More information about the R-help mailing list