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:
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: >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 >stat.ethz.ch/mailman/listinfo/r-help >PLEASE do read the posting guide >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