Import tools in Microsoft SQL Server Management Studio Express are almost non-existent; in Microsoft SQL Server Management Studio they are limited. The technique below will enable you to import an Access database into either Server Management Studio Express or Server Management Studio. In order to transfer the database, we shall do it via Access.

1] Get the access database from the link below.  [See Below!]

1] Using the mouse, hold down the Tools menu and select Database Utilities and select Upsizing Wizard  [See Below!]

2] You may either type in the server name or hold down the dropdown to search. My server is NET1. If the full version of Microsoft SQL Server Management Studio were installed, the server selection would be NET1. I would like my database to be called Hicks-Library.  Using the mouse, select/push the Next Button. [See Below!]

On the other hand, if you are using Microsoft SQL Server Management Studio Express, you will need to add \SQLExpress to the end of NET1. I would like my database to be called Hicks-Library.  Using the mouse, select/push the Next Button.  [See Below!]

3] The access database has 6 tables. Select those you wish to import.  [See Below!]

4] I have chosen to import all six tables. Using the mouse, Select/push the Next button.  [See Below]

5] Although this sample database does not have any relationships, indexes, or validation rules, I generally select the following. Using the mouse, select/push the Next Button.  [See Below!]

6] I am choosing to leave the original Access database unchanged. Using the mouse, select/push the Finish Button.  [See Below!]

7] You will see the tables being transferred  [See Below!]

8] You will get a progress report describing errors and successes. Take a look at it.  [See Below!] 

4]  Open Microsoft SQL Server Management Studio or Microsoft SQL Server Management Studio Express. Expand the Databases to see you new Hicks-Library database. Expand Tables to see Books, Genres, Majors, Students, TransactionDetails, and Transactions. Open Books to see if the data was transferred along with the table structures.  [See Below!] 

1]  The Library database is small and consists of only 6 tables. The Genre relates to the Books!

2]  The Library database is small and consists of only 6 tables. The Majors relate to the Students!

3]  A Check-OutTransaction occurs when a Student Checks out Books. A TransactionDetail is created for each and every Book checked out by the Student during a single Check-Out Transaction.

4]  A Database Administrator might provide the following glimpse into the Library Database.