David, You can certainly use RODBC to get to MS SQL, once you configure the ODBC connection in windows.
These days I tend to use RJDBC http://www.rforge.net/RJDBC/ which is a bit less of a hassle. Hint use the jtds driver http://jtds.sourceforge.net/ HTH, Jim Porzak Ancestry.com San Francisco, CA www.linkedin.com/in/jimporzak use R! Group SF: www.meetup.com/R-Users/ On Mon, Jan 25, 2010 at 2:55 PM, David Scott <d.sc...@auckland.ac.nz> wrote: > > I have a client running Microsoft SQL Server. I am interested in ways of > accessing data from this server using R. > > I would welcome any information about how this can be done. I have a > reasonable grasp of SQL and have experience with MySQL and RODBC but don't > know anything much about Microsoft SQL Server. > > David Scott > -- > _________________________________________________________________ > David Scott Department of Statistics > The University of Auckland, PB 92019 > Auckland 1142, NEW ZEALAND > Phone: +64 9 923 5055, or +64 9 373 7599 ext 85055 > Email: d.sc...@auckland.ac.nz, Fax: +64 9 373 7018 > > Director of Consulting, Department of Statistics > > ______________________________________________ > 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. ______________________________________________ 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.
