But the problem is that the dataframe size in sql is large, therefore odbc can sqlQuery() can not handel it.
On Fri, Oct 2, 2009 at 2:14 PM, Corrado <ct...@york.ac.uk> wrote: > 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<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 > > [[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.