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?
TableA source table
field1
field5
field8
TableB destination table
field1
field2
field3
field4
field5
field6
field7
field8
field9
field10
I need the TableA.field1, TableA.field5, TableA.field8 data to end in the
TableB.field1, TableB.field5, TableB.field8 columns.
thanks
nick