In this article, we make a database in Microsoft Access and that database is used in SQL Server.

So let's take a look at a practical example of how to import a Microsoft Access database table into SQL Server 2012. The example is developed in SQL Server 2012 using the SQL Server Management Studio. There are some simple steps to do that as described here.

Creating an empty database in SQL Server

Now Press F8 to open the Object Browser in SQL Server Management Studio and expand it.

Database -> right-click-> select New database

SQL

This would open the "New Database" window.

New database

Now enter a database name to create a database.

Create a database

Now click on the OK button to create the database. The database will be shown in the Object Explorer.

Test

Creating a table in the access database

Now open the Microsoft Access database and create a database. The Access database looks as in the following.

Table tool

Importing access database in SQL Server

Now right-click on the Test database and select the Import Data option.

database Name -> Tasks -> Import data

Import data

Now click on Import data. The import and export wizard will be opened.

Export wizard

Now select a Data Source. And browse the file from the system.

Microsoft Access

Now click on the Next Button enter the computer name or server name and select a database.

Server Name: MCNDESKTOP08\MYMSSQLSERVER

Database name: Test

Data Source

Now click on the Next Button.

Next Button

Now click on the Next Button.

Save and run

Now again click on the Next Button.

Finish

Now click on the Finish Button.

Close

And finally, click on the Close button.

All of your Access data is nicely imported into a SQL Server 2008 database. Now refresh the test database and expand it to see the imported table.

User detail