How to mass update one field in an existing table

We use a table to keep track of devices.  One field is the serial number of the device (Unique).  Another field is the date the device was last seen on the network.  This date is exported from anothe...