[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