Displaying 1 result from an estimated 1 matches for "odbcconnextexcel".
Did you mean:
odbcconnectexcel
2007 Mar 06
2
Package RODBC
I have some questions about the RODBC package.
library(RODBC) # required for those who want to repeat these lines
1st, I noticed that the following sequence does not work:
channel <- odbcConnextExcel("test.xls")
tables <- sqlTables(channel)
name1 <- tables[1, "TABLE_NAME"] # this should be the name
plan1 <- sqlFetch(channel, name1) # bang!
odbcClose(channel)
However, I can circumvent this with:
channel <- odbcConnextExcel("test.xls")
ta...