[R] Import data from Access

[livia]

Hi, I want to import some data from Access and I am using the following
codes:

testdb <- file.path("c/../db1")
channel <- odbcConnect("testdb")
sqlFetch(channel,"tbl",colnames = TRUE, rownames = FALSE)

It comes out the error message:

1: [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver
Manager] Data source name not found and no default driver specified 
2: ODBC connection failed in: odbcDriverConnect(st, ...) 

Anyone can help me sort it out? Many thanks.

-- 
View this message in context: http://www.nabble.com/Import--data-from-Access-tf3847342.html#a10896743
Sent from the R help mailing list archive at Nabble.com.