[R] Re ading Excel 5.0 files with RODBC?

David Winsemius dwinsemius at comcast.net
Tue Apr 7 17:16:14 CEST 2009


On Apr 7, 2009, at 10:04 AM, Yuri Volchik wrote:

>
> Hi,
>
> 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.

If you have a version of Excel that will do all those things, then you  
should be able to write a very short VBA macro that will do it.  
Undoubtedly simpler than the route you are proposing.

-- 

David Winsemius, MD
Heritage Laboratories
West Hartford, CT




More information about the R-help mailing list