In VFP, there is no bulk insert, so you would need to do it one record at a time

use bigtable
use smalltable in 0 order candkey
scan for eof("smalltable")
     scatter memvar
     insert into smalltable from memvar
endscan

>I was trying to do it more SQL-ish; is that possible? I thought using APPEND would lock the table header and make it less multiuser.
>
>
>>
>>It can't be done in one insert-sql in VFP; however, here's one quick way I've used before

>>use smalltable order candkey
>>append from bigtable ;
>>     for !indexseek(candkey, .f., "smalltable", "candkey")