Convert .mdb to SQL database

There's also the SQL Server Import and Export Wizard 

1. Open SSMS.
2. Create a new empty database.
3. Right-click the database in the Object Explorer.
4. Select Tasks | Import Data... from the context menu.
5. Change the data source to Microsoft Access.
6. Browse for the file name.
7. Click Next...
8. That's it :-)