Displaying 1 result from an estimated 1 matches for "scantables".
2003 Sep 23
1
RODBC access to MS-Excel (PR#4266)
...ortet by a commercial software, so I
cannot influence it. The problem is, that the names of the tables include
spaces, e.g. "Scan 1","Scan 2" etc. If I use RODBC, I get back something like
this
> channel<-odbcConnectExcel(fileName)
> tables<-sqlTables(channel)
> scanTables<-tables[c(grep("Scan",tables[,"TABLE_NAME"])),]
> scanTables
TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS
16 <NA> 'Scan 1$' TABLE <NA>
4 <NA> 'Scan 10$' TABLE <NA>
5 <NA> 'Scan...