Skip to content

Help on database!

3 messages · Nuno Miguel Brites, Dirk Eddelbuettel, W@y@e@W@Jo@es m@iii@g oii sheii@com

Original
Nuno Miguel Brites
# 
Hi!

I need to make a small linkage between R and a database 
(for eg, MSAccess). Is it possible?

Thanks.

Regards,
Brites
Dirk Eddelbuettel
#
On 28 July 2009 at 17:04, Nuno Miguel Brites wrote:
| I need to make a small linkage between R and a database 
| (for eg, MSAccess). Is it possible?

Yes.

You want to read the manual 'R Data Import/Export that came with your
installation of R, and is also available on each CRAN mirror, e.g. at
http://neacm.fe.up.pt/CRAN/doc/manuals/R-data.html from the U Porto mirror
that should be closest to you.

Hth, Dirk
W@y@e@W@Jo@es m@iii@g oii sheii@com
# 
Hi Brites, 

I suggest you look up the package RODBC. 

Its very quick and easy to use. Here is a dummy example: 

channel<-odbcConnectAccess("MyDb.mdb")
sqlQuery(channel,"select * from Table1")

-----Original Message-----
From: r-sig-db-bounces at stat.math.ethz.ch
[mailto:r-sig-db-bounces at stat.math.ethz.ch]On Behalf Of Nuno Miguel
Brites
Sent: 28 July 2009 17:04
To: r-sig-db at stat.math.ethz.ch
Subject: [R-sig-DB] Help on database!


Hi!

I need to make a small linkage between R and a database 
(for eg, MSAccess). Is it possible?

Thanks.

Regards,
Brites

_______________________________________________
R-sig-DB mailing list -- R Special Interest Group
R-sig-DB at stat.math.ethz.ch
https://stat.ethz.ch/mailman/listinfo/r-sig-db