Can someone throw light on the following problem I am having with RODBC?
There's an Excel file I am trying to read from, it has one sheet named
'nameclass'.
Thanks in anticipation.
Vishal Belsare
> library(RODBC)
> con = odbcConnectExcel(file.choose())
> tbls <- sqlTables(con)
> tbls
TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS
1 T:\\data\\in\\nameclass <NA> nameclass$ SYSTEM TABLE <NA>
> qry = paste("SELECT * FROM '",tbls$TABLE_NAME[1],"'",sep="")
> result = sqlQuery(con,qry)
> result
[1] "[RODBC] ERROR: Could not SQLExecDirect"
[2] "42000 -3506 [Microsoft][ODBC Excel Driver] Syntax error in FROM
clause."
[[alternative HTML version deleted]]
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
