...
- 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...
- 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 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.
...