Displaying 1 result from an estimated 1 matches for "sqlclear".
Did you mean:
pqclear
2009 Apr 27
1
RODBC - XLSX files - dropping/clearing sheets
...d is that you can't clear or drop sheets from the XLSX
files, as per the following example:
> library(RODBC)
> xlsx<-odbcDriverConnect("DRIVER=Microsoft Excel Driver (*.xls, *.xlsx,
*.xlsm, *.xlsb);DBQ=c:\\documents and settings\\desktop\\testxlsx.xlsx;
ReadOnly=False")
> sqlClear(xlsx,"newsheet2",errors=TRUE)
[1] "[RODBC] ERROR: Could not
SQLExecDirect"
[2] "HY000?Þêÿÿ\003 -5410 [Microsoft][ODBC Excel Driver] Deleting data in a
linked table is not supported by this ISAM."
> sqlClear(xlsx,"newsheet2",errors=TRUE)
[1] "[RODBC]...