[R] Embed SQL queries in R?

Marc Schwartz marc_schwartz at comcast.net
Fri Nov 14 16:22:06 CET 2008

on 11/14/2008 09:12 AM Brigid Mooney wrote:
> Hi All,
> Most of the work I am doing with R uses data which I am pulling from various
> SQL queries.
> To streamline the process even more, I was wondering if it was possible to
> embed SQL queries in R - that way avoiding the need to first get the data,
> then move to R to process it.
> I haven't found anything out there on this yet, so if you know of a good
> resource that includes this topic, I would really appreciate it.
> Thanks again for all your help!

You can secure data directly from most common relational data sources
within R. This is covered in the R Data Import/Export Manual:


and is also available with your R installation.

There is also a R e-mail list specifically on database interfaces:



Marc Schwartz

More information about the R-help mailing list