>If I have a destination table (DBF) that containes 10 columns and my source table (DBF) has 3 columns, how would I append the 3 source table columns into specific destination columns?
>...
>I need the TableA.field1, TableA.field5, TableA.field8 data to end in the
>TableB.field1, TableB.field5, TableB.field8 columns.

Hi Nick,

If the column names are the same you can just use APPEND FROM. You can also use the INSERT command with the SELECT clause, this is handy if the column names are different.

SELECT tableb
APPEND FROM tablea

** or **

INSERT INTO tableb (field1, field5, field8) ;
 SELECT field1, field5, field8 FROM tablea