Message-ID: <3EF96382.70602@sentoo.sn>
Date: 2003-06-25T08:55:30Z
From: Renaud Lancelot
Subject: excel files and R
In-Reply-To: <6C8A8033ABC1E3468048ABC4F13CE572AB5FDD@synequanon01>
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