Thanks Sergey. I assume that I would need to get a list of fields from the source table and use it in the APPEND FROM command or can it be used without a field list even when some fields are missing from the source table?

>>Is there a fast process for copying records from one table to another when the source table doesn't have all the fields of the destination table but you don't know which fields are missing in advance? There's between 30 and 35 fields in the source table and always 35 fields in the destination table. The source table can have millions of records.
>
>

APPEND FROM