Hi there,
If the tables have the same structure all you need to do is :
FileList=adir(SmallTable_xx.dbf)
&& For 1 Record Only .... Put it in a loop if you want it for more the one
&& record
Select "TableYouWantToExtractDataFrom"
SCATTER TO USEFULDATA && Copies the current record to Variable USEFULDATA
For Each SmallTable in FileList
Select "TableYouWantTOPutDataIn"
If EOF()
Append Blank
Endif
GATHER FROM USEFULDATA && Paste the record which was copied
Endfor
Hope it served you for some help
Regards