The ADTA copies data between two copies of a database, either replacing all the data (from specified tables) in one (Destination) from the other (Source), or updating and optionally appending one from the other. It also provides the ability to rapidly dump all data from all or selected tables. It automatically determines the correct delete and import orders based on the relationships in the Destination database and documents the record counts for each table before and after the process, as well as all table relationships, fields, and differences between the two databases. You can choose to include/exclude any or all tables in the process and cascading deletes are taken into account for excluded tables. There are other uses for the application too. The ADTA is also a great way to generate numerous append queries that you can import in bulk into another Access database.