[R] Pulling data from remote MySQL database

[HARROLD, Tim]

Agree - I started with RMySQL but eventually changed over to RODBC when I realised some of the additional functionality it contains and the fact that I needed to access different types of RDBMSs (e.g. acquire data from a Microsoft access database file).

Cheers,
Tim

-----Original Message-----
From: r-help-bounces at r-project.org [mailto:r-help-bounces at r-project.org] On Behalf Of David A. Johnston
Sent: Wednesday, 22 June 2011 8:22 AM
To: r-help at r-project.org
Subject: Re: [R] Pulling data from remote MySQL database

Hi Joseph,

I know that the RMySQL and RODBC packages allow you to pull the result of a
MySQL query into a data.frame within R.  

I like RODBC because you can access many different flavors of RDBMS's. 

-David Johnston

--
View this message in context: http://r.789695.n4.nabble.com/Pulling-data-from-remote-MySQL-database-tp3615351p3615523.html
Sent from the R help mailing list archive at Nabble.com.

______________________________________________
R-help at r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.


______________________________________________________________________________________________________________________
This email has been scanned for the NSW Department of Health by the Websense Hosted Email Security System. 
The Department regularly monitors emails and attachments to ensure compliance with its Electronic Messaging Policy.
______________________________________________________________________________________________________________________


______________________________________________________________________________________________________________________
Disclaimer: This message is intended for the addressee named and may contain confidential information. 
If you are not the intended recipient, please delete it and notify the sender. 
Views expressed in this message are those of the individual sender, and are not necessarily the views of NSW Health.
______________________________________________________________________________________________________________________
This email has been scanned for the NSW Department of Health by the Websense Hosted Email Security System. 
The Department regularly monitors emails and attachments to ensure compliance with its Electronic Messaging Policy.