[R] excel files and R

Renaud Lancelot lancelot at sentoo.sn
Wed Jun 25 10:55:30 CEST 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)
[snip]

It is no longer true since Pr Ripley provided a function 
odbcConnectExcel() (as well as odbcConnectAccess() and others) in the 
latest version of package RODBC. See the help file(s).

Best,

Renaud

-- 
Dr Renaud Lancelot, vétérinaire
CIRAD, Département Elevage et Médecine Vétérinaire (CIRAD-Emvt)
Programme Productions Animales
http://www.cirad.fr/fr/pg_recherche/page.php?id=14

ISRA-LNERV                      tel    +221 832 49 02
BP 2057 Dakar-Hann              fax    +221 821 18 79 (CIRAD)
Senegal                         e-mail renaud.lancelot at cirad.fr




More information about the R-help mailing list