Hello,
in general, there is RODBC package for general ODBC connection.
This works for me well (Windows NT, with name.of.server in ODBC sources):
library(RODBC)
str1 <- "some.sql.select"
channel <-
odbcConnect("name.of.database","","",host="name.of.server")
#
connects to database
BTS <- sqlQuery(channel, str1) # runs SQL command
odbcClose(channel)
I think there are even some packages for specific RDBMS, like Postgres, but
I am quite happy with RODBC
Jan
- - - Original message: - - -
From: owner-r-help at stat.math.ethz.ch
Send: 27/01/2002 3:35:33 PM
To: <r-help at lists.r-project.org> "Petra Steiner" <steinep
at uni-muenster.de>
Subject: [R] DBM databases for R?
Hello!
Can I use DBM databases (as they are used in Perl) for the import of
large datasets in R?
Thanks in advance for your help,
Petra Steiner
-
---------------------------------------------------
Petra Steiner
Arbeitsbereich Linguistik
Universitaet Muenster
Huefferstrasse 27
48149 Muenster
Tel: 0251 / 83 39442
petra at marley.uni-muenster.de
http://santana.uni-muenster.de/~petra/
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.
-.-.-
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
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._