Recover a missing field from a DB backup

[HiTekRedNek]

I have a database that contains a list of servers along with other fields such as contact numbers, server function, joined domain and others.
One of the fields containing telephone numbers was accidently deleted by user error. Fortunately I have a week old backup of the database still containing the missing field. There are quite a few records that get deleted and updated in the span of a week however I'd like to salvage any of the telephone numbers as possible. Both tables are identical and the main common field is "System_Name". How would I go about running a query that would look at all the servers listed under the "System_Name" field that exist in both tables and import the "telephone_numbers" field from the external backup database over to the current database. The only field that should get updated is "telephone_numbers".

I've never linked tables but I'm guessing that would be where I would start. Any suggestions?

 

[Mr. B]

Yes, you are on the right track. You can either link to the backup table or you can actually import the table from the backup file. I would just link to the table.

Then create query containing both tables linked on the "System_Name" field this will return only records where the two recordsets are the same. Then make that query an Update type query and update the phone number field in the current table to the value from the backup table.

Once you have run the query, you can just delete the linked table.

 

[HiTekRedNek]

It worked like a charm. Thanks!

 

[Mr. B]

Glad to help.