mack - 4:45 pm on Dec 20, 2012 (gmt 0)
If there are similarities between the tables that might be a good starting point. Even better if both tables share at least one piece of unique data. It would be perfect if both tables shared an ID field where the values matched up.
You could then do something like...
Select * from table
get the col values
insert data into table 2 where the ID matched.