From SQL Management Studio, create an empty database to hold the tables you wish to import.
Right click on the database name, then choose Tasks/Import data from the popup menu - you should then be able to connect to the access database and import the tables - Select Microsoft Access as the data source - the rest of the process is fairly easy to work out