[R] odbcFetchRows not work?

solares@unsl.edu.ar solares at unsl.edu.ar
Wed Apr 14 17:58:09 CEST 2004


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)
> tbl
$data
list()

$stat
[1] -1

> tbl<- odbcFetchRows(canal, max = 10)
> tbl
$data
list()

$stat
[1] -1




More information about the R-help mailing list