Use the import / export wizard to import MS Access tables to SQL Server.

Step-by-step guide

Open SSMS. (SQL Server Management Studio)
Right-click on Databases in the object explorer.
Select New Database
Create the LPad Database.
Right-click on the LPad database in the object explorer.
Select Tasks | Import Data... from the context menu.
Click Next...
Change the data source to Microsoft Access.
Browse for lpad.mdb. Click Next...
Click Next...
Click Next...
1. Check all source tables in the form. Also please make sure to look at the second screenshot to see which queries and tables need to be left unchecked. Click Next...
Check Run Immediately. Click Next..
Click Finish.
Close the wizard when the import is complete.

Browser not supported