excel files and R

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:ripley at stats.ox.ac.uk]
Sent: 24 June 2003 17:54
To: Victor H. Mar?m
Cc: r-help at stat.math.ethz.ch
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.
________________________________________________________________

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,                  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 stat.math.ethz.ch mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help
 

Simon Fear
Senior Statistician
Syne qua non Ltd
Tel: +44 (0) 1379 644449
Fax: +44 (0) 1379 644445
email: Simon.Fear at synequanon.com
web: http://www.synequanon.com
 
Number of attachments included with this message: 0
 
This message (and any associated files) is confidential and\ con... {{dropped}}