hi,
thank you,

it is copy just one record(first record)only. i have more than 150 records at xldata.dbf.

USE xldata
SCATTER memvar MEMO
USE nan
*!* either append blank or seek correct record to update
if eof("nan")
    append blank 
endif
&& i need to replace (delete all data replace new data)
GATHER memvar field EXCEPT char28 MEMO

thanks.
best regards
m.qasem