[R] Reading Excel files...Error

[Uwe Ligges]

Vivek Subramanian wrote:

> hi,
> i am using the RODBC package to read .xls files. now after i installed
> the package and loaded the library and tried to read a file this is
> the error i got.
> 
> 
>>channel<-odbcConnect("D:/rstuff/1.xls")

"D:/rstuff/1.xls" is not a DSN. Probably you are going to use 
odbcConnectExcel() in this case ...

Uwe Ligges


> Warning messages:
> 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, case = case,
> believeNRows = believeNRows)
> 
> please help me.
> 
> regards,
> vivek
> 
> ______________________________________________
> R-help at 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