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")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
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
If you need work-around, than you can always save excel file in csv format and than read that. See 'read.csv' or 'read.csv2'. Jarek ====================================================\====== Jarek Tuszynski, PhD. o / \ Science Applications International Corporation <\__,| (703) 676-4192 "> \ Jaroslaw.W.Tuszynski at saic.com ` \ -----Original Message----- From: r-help-bounces at stat.math.ethz.ch [mailto:r-help-bounces at stat.math.ethz.ch] On Behalf Of Vivek Subramanian Sent: Wednesday, June 15, 2005 5:28 AM To: rhelp Subject: [R] Reading Excel files...Error 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")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