How to connect .mdb file

[imnew]

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")
channel

and it gave me this :
RODBC Connection 3
Details:
case=nochange
DBQ=C:\USers\JieYi\Documents\NYP\IPP\GCR
Driver={Microsoft Access Driver (*.mdb)}
DriverId=25
FIL=MS Access
MaxBufferSize=2048
PageTimeout=5
UID=admin

I have a total of 5 tables in the .mdb database. any one can help me with
how to get the tables in ?

[Jeff Newmiller]

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:<[hidden email]>        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 <[hidden email]> 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")
>channel
>
>and it gave me this :
>RODBC Connection 3
>Details:
>case=nochange
>DBQ=C:\USers\JieYi\Documents\NYP\IPP\GCR
>Driver={Microsoft Access Driver (*.mdb)}
>DriverId=25
>FIL=MS Access
>MaxBufferSize=2048
>PageTimeout=5
>UID=admin
>
>I have a total of 5 tables in the .mdb database. any one can help me
>with
>how to get the tables in ?
>
>--
>View this message in context:
>http://r.789695.n4.nabble.com/How-to-connect-mdb-file-tp4636083.html
>Sent from the R help mailing list archive at Nabble.com.
>
>______________________________________________
>[hidden email] 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.

______________________________________________
[hidden email] 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.

[Mikhail Titov-2]

imnew <[hidden email]> writes:

> 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")
>
> I have a total of 5 tables in the .mdb database. any one can help me with
> how to get the tables in ?

You are one step away. Use sqlFetch(channel, "table_name") to fetch a
table into a data.frame as is. Or use sqlQuery(channel, sql) . Lookup
those functions in the manual.

--
Mikhail

______________________________________________
[hidden email] 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.