Hello,

I noticed that I made a small error in a query that resulted in one field of data getting slightly messed up. I need to get the entire column from my backup dB and put it in my heavily edited dB table.

If I restore, then I will loose unkown amount of changes so I'm hoping to swap fields out! The sort order on everything is unchanged.

Is there an easy way to do this?

import the table from the old db into the current db
then run and update query
providing there is a unique reference that is the same in both tables that should work. that unique reference should replace acolumn.

the way this works is that you tell the SQL engine to replace the value of mycolumn with t he value form the othertable where there is a match between the a column values. if you need more than one column to identify a row uniquely then
repalce the mycolumn, othertablename, a column etc with your own table /column names