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 <[EMAIL PROTECTED]> 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
>
> ______________________________________________
> [email protected] 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]]
______________________________________________
[email protected] mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
