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:<jdnew...@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 <jubil...@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@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. ______________________________________________ R-help@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.