Re: [R] error message of RODBC...

2009-01-05 Thread 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:

[R] error message of RODBC...

2009-01-05 Thread giovanni parrinello
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