[R] Generating reports from database
Cedrick W. Johnson
cedrick at cedrickjohnson.com
Mon Feb 22 12:09:30 CET 2010
List Requirements:
"
PLEASE do read the posting guide [1]http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
"
With that said.. We need a *bit* more information.... What database are you
connecting to? MySQL? MSSQL? Are you on Windows? Linux?
[2]https://stat.ethz.ch/mailman/listinfo/r-sig-db With a lil bit of
Googling, I found: [3]http://www.statmethods.net/input/dbinterface.html
which highlights RODBC and the other access methods for retrieving data from
DBMS's for use in R. I personally use RODBC and RMySQL for working with
data. Regards, -cedrick On 2/22/2010 5:38 AM, chinna wrote:
MY REQUIREMENT:
I have a database and i want to connect to the database through R Project
and using the tables from the database i need to generate the reports.
can anyone plese tell me whether this is possible with R project or not.
Thanks in advance
Chinna.
References
1. http://www.R-project.org/posting-guide.html
2. https://stat.ethz.ch/mailman/listinfo/r-sig-db
3. http://www.statmethods.net/input/dbinterface.html
More information about the R-help
mailing list