>>>I think I remember descriptions of appending data from one table to another with field mapping. IE table1.name goes into table2.fullname. But I can't seem to find any current help on this subject except with the import wizard which seems to only support non dbf files. Am I imagining things or is this still possible?
>>
>>You can do that with

>>INSERT INTO DestTable (<Destination Field list>) SELECT <Source Field list> FROM SourceTable
>>

>
>Thanks Sergey.
>Works great!

You're welcome