>>Does VFP 7.0 support INSERT INTO cTable NAME loData? This would be better than GATHER NAME followed by APPEND BLANK. TIA
>
>Nope, but its not a bad Idea. I've always wanted to do this as well:
>
>

INSERT INTO myTable ;
>   SELECT * ;
>      FROM myOtherTableWithTheSameStructure

SELECT myTable
APPEND FROM myOtherTableWithTheSameStructure

-or-

APPEND FROM DBF("myOtherTableWithTheSameStructure")

if it's a cursor.


Doesn't that work for you?