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 Simon Fear Senior Statistician Syne qua non Ltd Tel: +44 (0) 1379 644449 Fax: +44 (0) 1379 644445 email: [EMAIL PROTECTED] web: http://www.synequanon.com Number of attachments included with this message: 0 This message (and any associated files) is confidential and\ con... {{dropped}} ______________________________________________ [EMAIL PROTECTED] mailing list https://www.stat.math.ethz.ch/mailman/listinfo/r-help