imnew <jubil...@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 ______________________________________________ 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.