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