Reader Level:
ARTICLE

Importing Access Database into SQL Server 2012

Posted by Rohatash Kumar Articles | SQL Server September 20, 2012
This article demonstrates how to create an Access database and import it into a SQL Server database.
  • 0
  • 0
  • 16922

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 a 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-data-in-sqlserver.jpg

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

Import-and-export-wizard-in-sqlserver.jpg

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

select-datasource-and-filename-in-sqlserver.jpg

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-wizard-with servername-and-databasename-in-sqlserver.jpg

Now click on the Next Button.

access-table-import-wizard-in-sqlserver.jpg

Now click on the Next Button.

Import-export-with-next-in-sqlserver.jpg

Now again click on the Next Button.

Complete-wizard-in-sqlserver.jpg

Now click on the Finish Button.

successful-execution-in-sqlserver.jpg

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. 

Imported-database-in-sqlserver.jpg

COMMENT USING

Trending up