How to convert MS Access Database into SQL Server database?

My sample Access database looks like below with two tables (emp and dept)


Steps to be followed to convert MS Access Database into SQL Server database:

Step 1 :
Create New Database in the SQL Server



Step 2 :
Select newly created database and right click on that database then choose Tasks --> Import Data



New pop up window is opened then you can select in that pop up window "Microsoft Access" in the data source drop down list and choose file path using browse option.



Then click "Next" Button new screen in opened in that screen select Authentication as "Windows Authentication" If you have SQL Server user authentication then use that option otherwise better to use "Windows Authentication" for local system. Finally check restore database name correct or not last of the same screen.



Then click "Next" Button new screen is opened in that screen Check the option "Copy data from one or more tables or views".



Then click "Next" Button new screen is opened in that screen you can select all tables are convert to that SQL Server database or particular tables want to convert into SQL Server database



Then click "Next" Button new screen is opened in that screen you click the "Run Immediately" check box.



Then finally click "Finish" Button in that pop window, process is executed like below



After complete process your MS Access database convert into SQL Server database like below.



Note: If you don't have Import option then use DTSWizard it's available on the below path.
"C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe"

Conclusion:
I hope this article is help you to convert MS Access into SQL Server database.