Hello,

Yes you can copy all records using this code

select * from SourceTable where.(whereClause) into cursor JustCopy
sele 0
use DestinationTable
append from dbf('JustCursor')

Or

sele 0
use DestinationTable
append from SourceTable for (WhereClause)

Also You can see "append from" command Help Topic

Best regards

Sevdalina Draganova