Displaying 2 results from an estimated 2 matches for "scenario10".
Did you mean:
scenario1
2010 May 04
1
strange behavior of RODBC and/or ssconvert
...rt
can convert to, but only excel supports multisheets.
Best,
Stefan
Example code:
system(paste('ssconvert "excelcohortdata_men_reference scenario.xml"
"excelcohortdata_men_reference scenario22.xls"'))
channel1<-odbcConnectExcel("excelcohortdata_men_reference scenario10.xls")
odbcGetInfo(channel1)
sqlTables(channel1)
sqlQuery(channel1, "select * from \"age 9in 2010$\"" )
sqlFetch(chanel1, "age 9in 2010""
2010 May 05
0
R-help Digest, Vol 87, Issue 5
...rt
can convert to, but only excel supports multisheets.
Best,
Stefan
Example code:
system(paste('ssconvert "excelcohortdata_men_reference scenario.xml"
"excelcohortdata_men_reference scenario22.xls"'))
channel1<-odbcConnectExcel("excelcohortdata_men_reference scenario10.xls")
odbcGetInfo(channel1)
sqlTables(channel1)
sqlQuery(channel1, "select * from \"age 9in 2010$\"" )
sqlFetch(chanel1, "age 9in 2010""
------------------------------
Message: 45
Date: Tue, 4 May 2010 23:58:44 +0900
From: Luis N <globophobe at gmail.c...