R help - Jul 2012 - How to connect .mdb file

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.

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")
>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.
>
>______________________________________________
>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.

imnew <jubileee at live.com.sg> 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