[R] Re ading Excel 5.0 files with RODBC?

Prof Brian Ripley ripley at stats.ox.ac.uk
Wed Apr 8 10:19:00 CEST 2009


On Wed, 8 Apr 2009, Yuri Volchik wrote:

>
> Thanks for reply David,
>
> but the problem is that the place i get those files from saves them in the
> old Excel format (Excel 5.0), not Excel 97-2003, so neither of the packages
> (RODBC, xlsReadWrite) can read it.

RODBC supports any format for which an ODBC driver is installed and 
Microsoft have long supplied ones for Excel 3.0 and later (up to Excel 
2007 at present).

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




More information about the R-help mailing list