Re: [R] Reading Excel files...Error

From: Tuszynski, Jaroslaw W. <JAROSLAW.W.TUSZYNSKI_at_saic.com>
Date: Wed 15 Jun 2005 - 22:03:01 EST


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@saic.com                     `    \



-----Original Message-----
From: r-help-bounces@stat.math.ethz.ch
[mailto:r-help-bounces@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@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

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 Received on Wed Jun 15 22:06:53 2005

This archive was generated by hypermail 2.1.8 : Fri 03 Mar 2006 - 03:32:40 EST