[R] odbcFetchRows not work?

[Uwe Ligges]

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