search for: scantabl

...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> 'Sca...