Query to the relative data in both tables, export table two to excel, copy records (column) from excel, start an edit session on table one, right click the first record of your field and paste. As long as the records match exactly and are in the correct order you shouldn't have any issues.
... View more