How to connect .mdb file

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

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 ?
Reply | Threaded
Open this post in threaded view
|

Re: How to connect .mdb file

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.
Reply | Threaded
Open this post in threaded view
|

Re: How to connect .mdb file

Mikhail Titov-2
In reply to this post by imnew
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.