I have about 20 access databases, one for each year from 1990-2010. Each databases has pretty much the same tables, but unique data within those tables. (There are some unique tables, but they aren't very important.)

I am using SQL Server Migration Assistant for Access, but so far I can only figure out how to migrate one access database to one SQL database. Is it possible to either:

1. Use SSMA to import each database to my SQL server, while APPENDING rather than overwriting tables that already exist in the target database
2. Use SQL to merge 20 databases (after I've imported each one), appending together any similar tables

Each database has a few hundred tables, so I'm trying to avoid a manual solution.

Thank you!