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 ______________________________________________ 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.