Hi, excuse me i am newbee in R, but i dont understand the following code not work. Libro1.xls have two files and not load in R, under windows. Thanks library(RODBC)> f<-file.choose() > f[1] "C:\\Mis documentos\\ruben\\r19\\Libro1.xls"> help(odbcConnectExcel) > canal<- odbcConnectExcel(f) > canalRODB Connection 0 Details: case=nochange DBQ=C:\Mis documentos\ruben\r19\Libro1.xls DefaultDir=C:\Mis documentos\ruben\r19 Driver={Microsoft Excel Driver (*.xls)} DriverId=790 MaxBufferSize=2048 PageTimeout=5> help(odbcFetchRows) > tbl<- odbcFetchRows(canal, max = 0) > tbl$data list() $stat [1] -1> tbl<- odbcFetchRows(canal, max = 10) > tbl$data list() $stat [1] -1
solares at unsl.edu.ar wrote:> Hi, excuse me i am newbee in R, but i dont understand the following code > not work. Libro1.xls have two files and not load in R, under windows. Thanks > > library(RODBC) > >>f<-file.choose() >>f > > [1] "C:\\Mis documentos\\ruben\\r19\\Libro1.xls" > >>help(odbcConnectExcel) >>canal<- odbcConnectExcel(f) >>canal > > RODB Connection 0 > Details: > case=nochange > DBQ=C:\Mis documentos\ruben\r19\Libro1.xls > DefaultDir=C:\Mis documentos\ruben\r19 > Driver={Microsoft Excel Driver (*.xls)} > DriverId=790 > MaxBufferSize=2048 > PageTimeout=5 > >>help(odbcFetchRows) >>tbl<- odbcFetchRows(canal, max = 0)I think you are looking for sqlFetch() or sqlQuery() ... Uwe Ligges>>tbl > > $data > list() > > $stat > [1] -1 > > >>tbl<- odbcFetchRows(canal, max = 10) >>tbl > > $data > list() > > $stat > [1] -1 > > ______________________________________________ > R-help at stat.math.ethz.ch mailing list > https://www.stat.math.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html