[R] How to connect .mdb file

Mikhail Titov mlt at gmx.us
Wed Jul 11 08:04:28 CEST 2012

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.


More information about the R-help mailing list