The append to the new FoxPro table can also be coded this way:

select mytable
append from dbf( 'xcursor' )

as well as the aforementioned:

select xcursor
scan
scatter to memvar memo
insert into mytable from memvar
select xcursor
endscan

It takes less code, but I'm not completely sure which would be quicker with large amounts of data (although I would guess that the append would be).

Regards,

Mike