Re: [R] Rcmdr importing excel files

From: Prof Brian Ripley <ripley_at_stats.ox.ac.uk>
Date: Tue, 26 Feb 2008 23:10:22 +0000 (GMT)

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

______________________________________________
R-help_at_r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
Received on Tue 26 Feb 2008 - 23:13:11 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Wed 27 Feb 2008 - 00:30:16 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive