Displaying 2 results from an estimated 2 matches for "hoja3".
Did you mean:
hoja
2004 Apr 02
1
convert excell file to text with RODBC package
...:/prueba4.xls")
> tablas<-sqlTables(canal)
> tablas
TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS
1 c:\\prueba4 <NA> Hoja1$ SYSTEM TABLE <NA>
2 c:\\prueba4 <NA> Hoja2$ SYSTEM TABLE <NA>
3 c:\\prueba4 <NA> Hoja3$ SYSTEM TABLE <NA>
> tbl<-sqlFetch(canal,substr(tablas[1,3],1,nchar(tablas[1,3])-1))
> tbl[1]
D??a
1 2003-12-15 00:00:00
2 2003-12-15 00:00:00
3 2003-12-15 00:00:00
4 2003-12-15 00:00:00
5 2003-12-15 00:00:00
6 2003-12-15 00:00:00
7 2003-12-15 00:00:00
8 2003-12-...
2004 Apr 03
1
Re: R-help Digest, Vol 14, Issue 3
...gt; tablas<-sqlTables(canal)
> > tablas
> TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS
>1 c:\\prueba4 <NA> Hoja1$ SYSTEM TABLE <NA>
>2 c:\\prueba4 <NA> Hoja2$ SYSTEM TABLE <NA>
>3 c:\\prueba4 <NA> Hoja3$ SYSTEM TABLE <NA>
> > tbl<-sqlFetch(canal,substr(tablas[1,3],1,nchar(tablas[1,3])-1))
> > tbl[1]
> D??a
>1 2003-12-15 00:00:00
>2 2003-12-15 00:00:00
>3 2003-12-15 00:00:00
>4 2003-12-15 00:00:00
>5 2003-12-15 00:00:00
>6 2003-12-15 00...