I need to transfer a number of records from a table in one system (system 1) via floppy/email to another system (system 2). The table concerned has a memo field which needs to be transferred to system 2 as well.

System 1 extracts a selected number of records from vp1.dbf to a transfer file tvp1.dbf, then copies tvp1.dbf to the floppy, ie

use tvp1
append from vp1 for recno()>3000
copy file tvp1.dbf to a:\tvp1.dbf

To make sure that the memo contents of the selected records from vp1.dbf are transferred as well, I also include:

copy file vp1.fpt to a:\tvp1.fpt

and when the records from tvp1 are added to system 2, the memo field contents are added as well.

BUT of course tvp1.fpt above includes the memo contents of ALL records in vp1.dbf, which means it is a huge file and makes for a problem with disk space etc.

Question - Is there any way I can transfer the memo contents of the selected records ONLY in tvp1.dbf to tvp1.fpt?

Any ideas gratefully received