Moving Data to a 2nd Database

[joatmofn]

Somehow, we lost workorder hours for 2 of our employees. We discovered that the employees were completely removed from the employees table which was linked to a labor table with cascade delete enabled. How the two employees were removed is not yet determined. The employee form's delete button is not active. Anyway...

We had a backup of the database which contains the 2 employees and their workorder hours.

I need to extract that information from the backup mdb file and insert it into the current db but am not sure of how to proceed.

Should i query against the saved employees and extract to an excel spreadsheet, then import into the current db? Or should I create a query that builds a new table that contains only the data that needs to be restored, then perform an update query to copy it into the current db?

Just not sure which way, and exactly how to go about it. Any help would be much appreciated.

Thanks.

 

[nabiS2K]

I would recommend opening one of the two databases and creating linked tables to the other database. I would then use an append query to copy only the deleted employees from the backup to the live database.

 

[joatmofn]

Thanks for your suggestion. However, just after I posted my question, I tried the export to excel followed by an import into the live db. In between, I updated the employee id in the excel file to match the new empid (autonumber) of the 2 employees in the live db. Imported it into the existing labor table. Worked great. Again, thanks just the same.