>>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!