Re: [R] Fetch large sized file from SQL

I think you can specify the number of rows to be loaded at a time. It was quite a while ago. Try reading ?sqlQuery ?odbcConnect I have loaded quite large tables. On Friday 02 October 2009 14:59:59 Dr. Alireza Zolfaghari wrote: > But the problem is that the dataframe size in sql is large, there

Re: [R] Fetch large sized file from SQL

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 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 po

Re: [R] Fetch large sized file from SQL

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 dri

[R] Fetch large sized file from SQL

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]] __