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-boun...@r-project.org [mailto:r-help-boun...@r-project.org] On Behalf Of David A. Johnston Sent: Wednesday, 22 June 2011 8:22 AM To: r-help@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@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. ______________________________________________ R-help@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.
