Apply OS: Windows, Mac, Linux

Apply Navicat Product: All

Apply Navicat Version No.: All

If two tables are in the server, you can employ Data Synchronization to merge the tables.

  1. In General Tab, choose one table as Source Table and another as Target Table.
  2. In Advanced Tab, uncheck Delete records and click Start.
  3. The target table will become the resulted table after merging.

If two tables are in other formats (e.g. Excel, text ...), you can import the one file to a new table and then import another to the same table.

Note: The two table structures must be identical.

Have more questions?
Submit Ticket