You can try using RODBC, it allows you to connect to databases using the ODBC driver.
I had some difficulties using it with the postgresSQL driver in the past, because of some apparent incompatibility with the native postrgesSQL ODBC driver. I think the problem where solved by the new ODBC driver for postgresSQL and the new revision for RODBC. On Friday 02 October 2009 13:56:02 Dr. Alireza Zolfaghari wrote: > Hi List, > Does any one know what package I need to use in order to fetch/get a large > sized dataframe from SQL? I have already used sqldf package which is good > for fetching large sized csv files. > > Thanks > Alireza > > [[alternative HTML version deleted]] > > ______________________________________________ > 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. -- Corrado Topi Global Climate Change & Biodiversity Indicators Area 18,Department of Biology University of York, York, YO10 5YW, UK Phone: + 44 (0) 1904 328645, E-mail: ct...@york.ac.uk ______________________________________________ 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.
