## Merging two database files for the same hospital

Typically you need to merge data whenever you have collected survey data on more than one computer.

In the scenario described here, there are two computers, named A and B, each of which contains data collected from the same hospital (hospital code G01), but different wards. We are going to merge the data from computer B with that on computer A. The computers share a networked drive P.

The following table summarises the database names, location, and content:

Table 25: Properties used for merging Ward data

Hospital code | Computer | Wards | Original database | Location of database files | Data quality check required
G01 | A | W01, W02 | HelicsWinNet.mdb | C:\HWN2 | Yes
G01 | B | W11, W12 | HelicsWinNet.mdb | P:\HWN2 | Yes

More:

On computer A

HelicsWin.Net v2.2 Online User Guide v20160330
© European Centre for Disease Prevention and Control, 2016
Reproduction is authorised, provided the source is acknowledged