[R] How to connect .mdb file

Jeff Newmiller jdnewmil at dcn.davis.CA.us
Wed Jul 11 05:58:54 CEST 2012

Are you sure XYZ is the name of the MDB file? Perhaps you are being fooled by the default filename display that omits the extension?
Jeff Newmiller                        The     .....       .....  Go Live...
DCN:<jdnewmil at dcn.davis.ca.us>        Basics: ##.#.       ##.#.  Live Go...
                                      Live:   OO#.. Dead: OO#..  Playing
Research Engineer (Solar/Batteries            O.O#.       #.O#.  with
/Software/Embedded Controllers)               .OO#.       .OO#.  rocks...1k
Sent from my phone. Please excuse my brevity.

imnew <jubileee at live.com.sg> wrote:

>Hi, I'm currently having some problem connect .mdb file into R. 
>I've installed the RODBC packages and I do the code this way: 
>channel <- odbcConnectAccess("C:/Users/Documents/XYZ")
>and it gave me this :
>RODBC Connection 3
>Driver={Microsoft Access Driver (*.mdb)}
>FIL=MS Access
>I have a total of 5 tables in the .mdb database. any one can help me
>how to get the tables in ?
>View this message in context:
>Sent from the R help mailing list archive at Nabble.com.
>R-help at r-project.org mailing list
>PLEASE do read the posting guide
>and provide commented, minimal, self-contained, reproducible code.

More information about the R-help mailing list