[R] Import data from Access

From: livia <yn19832_at_msn.com>
Date: Thu, 31 May 2007 08:54:54 -0700 (PDT)

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_at_stat.math.ethz.ch mailing list
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
Received on Thu 31 May 2007 - 16:23:30 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Thu 31 May 2007 - 18:31:12 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.