Will that append the records to the target table?

Bill, no, it will not.

When you do a SELECT Field_List into NewTable from OldData, NewTable cannot already exist. (If it does, you'll get an error). So it's not additive.

SELECT INTO NewTable is great when the table doesn't exist - it gets created....but again, if it already exists, you'll get an error.


If you want to append rows into an existing target table...you can do an INSERT INTO....SELECT....such as

INSERT TO "TableYouWantToAppendTo" Select "columns" from ExistingTable. (You'll need to be careful with the matching column lists)

Hope that helps...