[R] Import data from Access

livia yn19832 at msn.com
Thu May 31 17:54:54 CEST 2007

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

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.

More information about the R-help mailing list