[R] Re ading Excel 5.0 files with RODBC?

Yuri Volchik yuri.volchik at gmail.com
Tue Apr 7 16:04:51 CEST 2009


i'm trying to read some data from excel files but it seems that neither
xlsReadWrite nor sqlFetch (RODBC) doesn't like the format (Excel 5.0). 
When i open the file in Excel and save it in a new format Excel 97 -2003
everything works fine.
Is it possible to use ODBC connection to open old format files, or i guess i
will have to open and save every file in Excel in new format, which isn't
very practical.

View this message in context: http://www.nabble.com/Reading-Excel-5.0-files-with-RODBC--tp22929781p22929781.html
Sent from the R help mailing list archive at Nabble.com.

More information about the R-help mailing list