How To Transfer Access database to SQL Server

In this we will learn how we use the access database over sql server.

1. Open SQL server Management studio and connect to the database
 
2. Inside the Database click on new database
    
3. Now Select a access database
   
   
    
    
4. Now choose a data source in access and select a Microsoft access
   
    
5. click on Browse and navigate to the Access database you want to import and click Open
    
6. Go ahead and click Next to choose the destination and you right-clicked on the database you wanted to import the data into, it should already be picked in the list.
   
   
7. 7.Click Next and then specify how you want to transfer the data from Access to SQL by choosing either Copy the data from one or more tables or write a query..

   
   

8. Now click the edit button

   
   
   

9. click Next and then choose whether to execute immediately or to save it as a file to perform later.

   
    

10. After it is completed, you'll see the number of rows transferred for each table in the Message column.

    
     

11. Click Close and you should now have all of your Access data nicely imported into a SQL Server 2008 database, which you can then use..