>I want to be able to do
>select * from X into DBF Y

I think it should be "into table Y" but this will over write table Y you know? It may be safter to select Y and do a APPEND FROM X, IMO.