I am trying to figure out a way to download an Excel file and then read a range into R - so that i can have a reasonably automated process. I have been trying to use the RODBC package, but with little success. I suspect that this isnt the right route
Here is some code. My aim is to read in the data starting in H69:H283 in sheet 2. v<-"http://www.statistics.gov.uk/elmr/01_09/downloads/Table1_07.xls"; dest<-"C:/Data/onstest.xls" download.file(url=v,destfile=dest,mode="wb") library(RODBC) channel <-odbcConnectExcel(dest) qry <- paste("SELECT * FROM '",tbls$TABLE_NAME[2],"'",sep="") onstest <- sqlQuery(channel,qry) close(channel) very grateful for any help simeon [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
