Re: [R] Rcmdr importing excel files
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, [EMAIL PROTECTED] 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, UKFax: +44 1865 272595 __ R-help@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.
Re: [R] Rcmdr importing excel files
Thanks very much. --- John Fox <[EMAIL PROTECTED]> 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. > > Regards, > John > > > John Fox, Professor > Department of Sociology > McMaster University > Hamilton, Ontario, Canada L8S 4M4 > 905-525-9140x23604 > http://socserv.mcmaster.ca/jfox > > > -Original Message- > > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > > project.org] On Behalf Of John Kane > > Sent: February-26-08 5:27 PM > > To: stephen sefick; r-help@r-project.org > > Subject: Re: [R] Rcmdr importing excel files > > > > I'm on Windows XP R 2.6.2 > > The command > > Data > Import > From Excel, Access etc > > Supply data.frame name > > Select xls file and then select the sheet seem to > work > > for me > > > > What is not showing? > > --- stephen sefick <[EMAIL PROTECTED]> wrote: > > > > > I am using R 2.6.2 on Mac OS X 10.4.9- I would > like > > > to import excel > > > files into R with Rcmdr, but This option does > not > > > present itself in > > > the file menu. Any help would be greatly > > > appreciated. > > > > > > Stephen > > > > > > -- > > > Let's not spend our time and resources thinking > > > about things that are > > > so little or so large that all they really do > for us > > > is puff us up and > > > make us feel like gods. We are mammals, and > have > > > not exhausted the > > > annoying little problems of being mammals. > > > > > > -K. Mullis > > > > > > __ > > > R-help@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. > > > > > > > __ > > R-help@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. > > __ R-help@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.
Re: [R] Rcmdr importing excel files
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. Regards, John John Fox, Professor Department of Sociology McMaster University Hamilton, Ontario, Canada L8S 4M4 905-525-9140x23604 http://socserv.mcmaster.ca/jfox > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > project.org] On Behalf Of John Kane > Sent: February-26-08 5:27 PM > To: stephen sefick; r-help@r-project.org > Subject: Re: [R] Rcmdr importing excel files > > I'm on Windows XP R 2.6.2 > The command > Data > Import > From Excel, Access etc > Supply data.frame name > Select xls file and then select the sheet seem to work > for me > > What is not showing? > --- stephen sefick <[EMAIL PROTECTED]> wrote: > > > I am using R 2.6.2 on Mac OS X 10.4.9- I would like > > to import excel > > files into R with Rcmdr, but This option does not > > present itself in > > the file menu. Any help would be greatly > > appreciated. > > > > Stephen > > > > -- > > Let's not spend our time and resources thinking > > about things that are > > so little or so large that all they really do for us > > is puff us up and > > make us feel like gods. We are mammals, and have > > not exhausted the > > annoying little problems of being mammals. > > > > -K. Mullis > > > > __ > > R-help@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. > > > > __ > R-help@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. __ R-help@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.
Re: [R] Rcmdr importing excel files
I'm on Windows XP R 2.6.2 The command Data > Import > From Excel, Access etc Supply data.frame name Select xls file and then select the sheet seem to work for me What is not showing? --- stephen sefick <[EMAIL PROTECTED]> wrote: > I am using R 2.6.2 on Mac OS X 10.4.9- I would like > to import excel > files into R with Rcmdr, but This option does not > present itself in > the file menu. Any help would be greatly > appreciated. > > Stephen > > -- > Let's not spend our time and resources thinking > about things that are > so little or so large that all they really do for us > is puff us up and > make us feel like gods. We are mammals, and have > not exhausted the > annoying little problems of being mammals. > > -K. Mullis > > __ > R-help@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. > __ R-help@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.
[R] Rcmdr importing excel files
I am using R 2.6.2 on Mac OS X 10.4.9- I would like to import excel files into R with Rcmdr, but This option does not present itself in the file menu. Any help would be greatly appreciated. Stephen -- Let's not spend our time and resources thinking about things that are so little or so large that all they really do for us is puff us up and make us feel like gods. We are mammals, and have not exhausted the annoying little problems of being mammals. -K. Mullis __ R-help@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.