Importing Access Database into SQL Server 2012

This article demonstrates how to create an Access database and import it into a SQL Server database.

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 expend it.
 
Database -> right-click-> select New database
 
Create-new-database-in-sqlserver.jpg
 
This would open the "New database" window:
 
New-Database-Window-in-sqlserver.jpg
 
Now enter a database name to create a database.
 
NewDatabase-window-with-database-name-in-sqlserver.jpg
 
Now click on the OK button to create the database. The new database will be shown in the Object Explorer:
 
Object-Explorer-with-new-database-in-sqlserver.jpg
 

Creating a Table in Access Database

 
Now open the Microsoft Access database and create a database.  The Access database looks as in the following:
 
access-database-in-sqlserver.jpg
 

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 Access database in SQL Server
 
Now click on Import data. The import and export wizard will be opened.
 
Import Access database in SQL Server
 
Now select a Data Source. And browse the file from the system.
 
Import Access database in SQL Server
 
Now click on the Next Button and enter the computer name or server name and select a database.
 
Server Name: MCNDESKTOP08\MYMSSQLSERVER
Database name: Test
 
Import Access database in SQL Server
 
Now click on the Next Button.
 
Import Access database in SQL Server
 
Now click on the Next Button.
 
Import Access database in SQL Server
 
Now again click on the Next Button.
 
Import Access database in SQL Server
 
Now click on the Finish Button.
 
Import Access database in SQL Server
 
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. 
 
Import Access database in SQL Server