How to load more than one MS-Access-db tables with data in SQL-Server-DB
In SSMS, you can right click on your target database, select Tasks...Import Data, then choose your Access database as the Source and then choose your target SQL Server database as the Destination.