Combine new records

[ScottXe]

From time to time, the database is required to be updated from a couple of different locations. I need to combine all the new records of those databases into the master database. Can someone advise me how to accomplish this task.

 

[PaulO]

Use individual APPEND queries to map and import data from your various data sources.

To avoid reading in duplicate records, link the Source Data table to the Database table using one or more (unique) fields and using the IsNull criteria against those same fields in the Database table.

 

[ScottXe]

It sounds to me that Append is not working to combine updated records in reality. I can imagine that each table may be added in new records. It is simple to be identified by the unique IDs. However, when the fields of records are updated, how does the table know about it and only update the field changed at the latest are merged. Can someone explain to me how Append works so I can prevent any known issues in advance. Thanks in advance!