Sloan,

You don't need to save xls as csv. Actually, R reads data in excel very 
well. Following code is cutted from my blog and HTH.

library(RODBC);

###########################################################
# 1. READ DATA FROM EXCEL INTO R #
###########################################################
xlsConnect<-odbcConnectExcel("C:\\temp\\demo.xls");
demo<-sqlFetch(xlsConnect, "Sheet1");
odbcClose(xlsConnect);
rm(demo);


On 9/12/05, sloan jones <sledepi@operamail.com> wrote:
> 
> I have been trying to open data that I have saved in an excel spread 
> sheet. I saved it as a csv. Then I tried using the read.csv command. 
> However, everytime I do this--
> 
> diseasedat<-read.csv("M:/sloan/R/disease/disease.csv", sep=, header = 
> TRUE, fill= TRUE)--
> 
> I get an error message:
> 
> Error in file(file, "r") : unable to open connection
> In addition: Warning message:
> cannot open file 'M:/sloan/R/disease/disease.csv'
> 
> What am I doing wrong or what should I look for to correct this?
> 
> Sloan
> 
> --
> _______________________________________________
> Surf the Web in a faster, safer and easier way:
> Download Opera 8 at http://www.opera.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
> 



-- 
WenSui Liu
(http://statcompute.blogspot.com)
Senior Decision Support Analyst
Cincinnati Children Hospital Medical Center

	[[alternative HTML version deleted]]


