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 <ct529@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: ct529@york.ac.uk
>
>

	[[alternative HTML version deleted]]


