If the NAN table has enough records:

CLOSE all
USE xldata
USE nan in 0
*select xldata && Already selected
SCAN
   SCATTER memvar 
   *!* either append blank or seek correct record to update
   SELECT NAN
   SKIP
   Blank FIELDS EXCEPT column19&& delete all data for all fields except column19 and go top of nan.dbf
   GATHER memvar field EXCEPT column19
   SELECT xldata
ENDSCAN

>hi,
>thank you very much,
>
>i need to delete all records form nan.dbf and REPLACE all data from xldata.NOT APPEND.
>
>

>CLOSE all
>USE xldata in 0
>USE nan in 0
>   Blank FIELDS EXCEPT column19&& delete all data for all fields except column19 and go top of nan.dbf
>
>select xldata
>SCAN
>   SCATTER memvar
>   *!* either append blank or seek correct record to update
>   SELECT NAN
>   append blank
>   && i need to replace (delete all data replace new data)
>   GATHER memvar field EXCEPT column19
>
>ENDSCAN
>
>

>
>thanks.
>m.qasem