[R] ODBC Connectivity

Yves Gauvreau cyg at sympatico.ca
Tue Nov 14 14:56:31 CET 2000


I've tried RODBC on both SQL Server and Access databases only to read in
some data. I think especially if the size of your data sets is relatively
small then RODBC will do the job. The only complaint I would have is the
speed at which it runs but again this is a generic tool, it is flexible
enough and relatively efficient for all the work it does. If you have
particular needs and speed is critical then you would probably want
something faster.

Hope this helps

YG


----- Original Message -----
From: "Samir Mishra" <samir.mishra at norkom.com>
To: "R-Help (E-mail)" <r-help at lists.R-project.org>
Sent: Tuesday, November 14, 2000 7:05 AM
Subject: [R] ODBC Connectivity


> Does anyone have any experience using R to pull/push data from an ODBC
> compliant database? I'm working on a small project and am undecided about
> whether to use just R or use some other software for extracting and
> transforming.
>
> TIA
>
> Samir.
>
>
> The information contained in this e-mail transmission is confidential and
may
> be privileged. It is intended only for the addressee(s) stated above.  If
you
> are not an addressee, any use, dissemination, distribution, publication,
or
> copying of the information contained in this e-mail is strictly
prohibited.  If you
> have received this e-mail in error, please immediately notify our IT
Department
> by telephone at 353-1-6769333 or e-mail mail.sweeper at norkom.com and
> delete the e-mail from your system.
> -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.
-.-.-
> r-help mailing list -- Read
http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
> Send "info", "help", or "[un]subscribe"
> (in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
>
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._.
_._

-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._



More information about the R-help mailing list