channel <- odbcConnectExcel("nuova tabella terapia occupazionale mod.xls")
> ## list the spreadsheets
> sqlTables(channel)
TABLE_CAT
TABLE_SCHEM TABLE_NAME
1 c:\\TABELLE DEFINITIVE\\nuova tabella terapia occupazionale mod
<NA> 'emi tot 2006 OAI_60g TO FU1$'
2 c:\\TABELLE DEFINITIVE\\nuova tabella terapia occupazionale mod
<NA> 'emi tot 2006 OAI_60g TO FU2$'
3 c:\\TABELLE DEFINITIVE\\nuova tabella terapia occupazionale mod
<NA> 'emi tot 2006 OAI_60GG divisi$'
4 c:\\TABELLE DEFINITIVE\\nuova tabella terapia occupazionale mod
<NA> 'emi tot 2006$'
5 c:\\TABELLE DEFINITIVE\\nuova tabella terapia occupazionale mod
<NA> 'RMI E SCALA SPECIFICA$'
6 c:\\TABELLE DEFINITIVE\\nuova tabella terapia occupazionale mod
<NA> 'VALORI RANKIN RMI CSS$'
TABLE_TYPE REMARKS
1 TABLE <NA>
2 TABLE <NA>
3 TABLE <NA>
4 TABLE <NA>
5 TABLE <NA>
6 TABLE <NA>
> table1=sqlFetch(channel,"emi tot 2006 OAI_60g TO FU1$")
> str(table1)
chr [1:2] "[RODBC] ERROR: Could not SQLExecDirect(?????)" ...
> sqlTables(channel)
[[alternative HTML version deleted]]
______________________________________________
[email protected] 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.
