KS DB Merge Tools logo KS DB Merge Tools
database diff & merge
AccdbMerge logo for MS Access
aka AccdbMerge
KS DB Merge Tools for Oracle logo
KS DB Merge Tools for MySQL logo
MssqlMerge logo
KS DB Merge Tools for PostgreSQL logo
KS DB Merge Tools for SQLite logo
KS DB Merge Tools for Cross-DBMS logo
KS DB Merge Tools All-In-One license

Diff & Merge Table Data

Open databases (see Project changes summary use case) and 1click on Table definitions:

for MS Access, home tab click table definitions

to open Object list tab with tables. Note that rows highlight here is related only to column definition changes (column names, types, etc) and not related to data changes. Then 2click 'Compare data' for the required table:

for MS Access, object list click compare data

to open Data diff tab with result. Here you can 3apply filter to show only changed and/or new rows:

for MS Access, data diff can show new or changed

To merge data changes to the other side you need to 4select required rows, if needed 5select required columns and 6click Merge:

for MS Access, data diff select rows and columns to merge