[R] Bringing dbf Data With SQL

[Jim Lemon]

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?

Jim