I have an 'old' table, and a 'new' table (updated structure, new fields, validation rules, etc). I need to copy all of the records from the old table into the new. Most of the field names are the same, and all the new fields are placed at the end. Is there an automatic way to do this, or will I have to write a procedure? The full table has about 75 fields, and +/- 100,000 records. (Yes its normalized, just happens to be a big table). Thanks.

Erik