Re: [R] odbcFetchRows not work?

About this list Date view Thread view Subject view Author view Attachment view

From: Uwe Ligges (ligges@statistik.uni-dortmund.de)
Date: Thu 15 Apr 2004 - 20:09:50 EST


Message-id: <407E5F6E.8010208@statistik.uni-dortmund.de>

solares@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@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

______________________________________________
R-help@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


About this list Date view Thread view Subject view Author view Attachment view

This archive was generated by hypermail 2.1.3 : Mon 03 May 2004 - 18:41:20 EST