There's a function odbcConnectExcel, a wrapper to odbcDriverConnect. Neither require any work with Windows menus.
On Wed, 25 Jun 2003, Simon Fear wrote: > RODBC works fine but as far as I can tell requires that the connection > be > opened through Windows menus. OK for a one-off, but not for batch > processing. > Please someone tell me what I missed - how can I open the connection > within > an R script? > (Windows 98)(not my fault) > > TIA > (sorry for long disclaimer, can't switch it off) > > -----Original Message----- > From: Prof Brian Ripley [mailto:[EMAIL PROTECTED] > Sent: 24 June 2003 17:54 > To: Victor H. Marím > Cc: [EMAIL PROTECTED] > Subject: Re: [R] excel files and R > > > Security Warning: > If you are not sure an attachment is safe to open please contact > Andy on x234. There are 0 attachments with this message. > ________________________________________________________________ > > On Tue, 24 Jun 2003, Victor H. Marím wrote: > > > I am new at R. My questions is rather basic. Looking R manuals looks > > like there should be a way to read MS excel files into R. Could > > somebody tell me which library should I use for that? > > Several ways are in the R Data Import/Export Manual (the obvious manual, > I > would have thought). If you are working on Windows, using RODBC is > perhaps the simplest. > > -- 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, UK Fax: +44 1865 272595 ______________________________________________ [EMAIL PROTECTED] mailing list https://www.stat.math.ethz.ch/mailman/listinfo/r-help