Displaying 1 result from an estimated 1 matches for "g69974".
Did you mean:
369974
2011 Mar 01
0
odbcConnectExcel2007 creates corrupted files
...el file
$ out <- odbcConnectExcel2007("test.xlsx", readOnly=FALSE)
$ test <- data.frame(x=1:10, y=rnorm(10))
$ sqlSave(out, test)
$ sqlTables(out)
TABLE_CAT TABLE_SCHEM
TABLE_NAME TABLE_TYPE REMARKS
1 C:\\Documents and Settings\\G69974\\My Documents\\test.xlsx <NA>
test$ SYSTEM TABLE <NA>
2 C:\\Documents and Settings\\G69974\\My Documents\\test.xlsx
<NA> test TABLE <NA>
$ sqlFetch(out, "test")
x y
1 1 0.5832882
2 2 0.4387569
3 3 -0.6444...