> library(RODBC)
> z <- odbcConnectExcel("c:/myfolder/mydata.xls")
> myframe <- sqlFetch(z, "Sheet1")
> close(z)
I found the reading of whole sheets somewhat unsafe, so I always create a named
range (here: data) including header and do the following.
Never had problems with this.
channel = odbcConnectExcel("macronutrients.xls")
ac = sqlQuery(channel,"select * from data")
odbcClose(channel)
Dieter
______________________________________________
[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
