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.
______________________________________________
R-help@stat.math.ethz.ch 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.
