library(RODBC); mdbConnect <- odbcConnectAccess("C:\\db.mdb"); data <- sqlFetch(mdbConnect, "tblData"); odbcClose(mdbConnect);
On 5/31/07, livia <[EMAIL PROTECTED]> wrote: > > > 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. > -- WenSui Liu A lousy statistician who happens to know a little programming (http://spaces.msn.com/statcompute/blog) [[alternative HTML version deleted]] ______________________________________________ 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.