Displaying 1 result from an estimated 1 matches for "1500tax".
Did you mean:
1500ap
2007 Mar 23
6
Updating a worksheet in Excel file using RODBC
...s (3 slightly different attempts):
> sqlSave(con, x, tablename = "Chimaera20_3years$", append = FALSE,
+ rownames = FALSE, colnames = TRUE,
+ verbose = TRUE, oldstyle = FALSE,safer=FALSE)
Query: CREATE TABLE Chimaera20_3years$ (Date varchar(255), 000Tax varchar(255), 1500Tax varchar(255), 3000Tax varchar(255), 4650Tax varchar(255))
Error in sqlSave(con, x, tablename = "Chimaera20_3years$", append = FALSE, :
[RODBC] ERROR: Could not SQLExecDirect
37000 -3551 [Microsoft][ODBC Excel Driver] Syntax error in CREATE TABLE statement.
> sqlSave(con, x,...