[R] Bringing dbf Data With SQL

Jim Lemon jim at bitwrit.com.au
Fri Oct 9 11:16:58 CEST 2009

On 10/09/2009 07:17 AM, Michael Yutzi wrote:
> I have a heavy DATA saved in dbf format.
> What I want is to bring that data to R with SQL statements. Like: I want
> columns 1, 4, 5 and only when column 4>  30.
> Sorry asking it here instead of keep searching in manuals, but it seems that
> there are too many ways of doing it. So what's the appropriate package that
> I need to work it, considering also that im dealing with lots of gigas so
> the faster way, better.
> I would really appreciate helps
> Thanks since now
Hi Michael,
Let's say your table is named "lotsadata" and the attributes are labeled 
"one", "two" and so on. Does:

SELECT one four five
  FROM lotsadata
  WHERE four<30.

do what you want?


More information about the R-help mailing list