[R] Rcmdr importing excel files

Prof Brian Ripley ripley at stats.ox.ac.uk
Wed Feb 27 00:10:22 CET 2008


On Tue, 26 Feb 2008, John Fox wrote:

> Dear John and Stephen,
>
> As I recall, importing from Excel, Access, or dBase files works properly
> only under Windows, and consequently the menu item appears only in Windows
> systems. I frankly don't recall why this is the case, since the RODBC
> package is used. The code for reading these kinds of files was contributed
> by Matthieu Lesnoff, to whom I'm copying this response. Maybe he'll have a
> more complete answer.

You don't just need the RODBC package, but also the MS ODBC drivers.
I'd be surprised if such drivers existed anywhere else, as they rely 
on Windows internals.

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