[R] error message of RODBC...

[Prof Brian Ripley]

No, error message from your ODBC driver ...

Your table names are not valid SQL names.  The details depend on the exact 
driver, but you could try omitting the final dollar.  This may not 
work, in which case you may need to use an sqlQuery call.

On Mon, 5 Jan 2009, giovanni parrinello wrote:

> 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]]


-- 
Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595