library(RODBC);
mdbConnect <- odbcConnectAccess("C:\\db.mdb");
data <- sqlFetch(mdbConnect, "tblData");
odbcClose(mdbConnect);

On 5/31/07, livia <yn19832@msn.com> 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]]

