Before starting conversion, copy MDF file to SQL Server.
Go to start button all Programs -> Microsoft SQL SERVER 2008 -> SQL SERVER Management Studio -> Right click -> Run as Administrator.
Click on run as administrator. You will see a popup box asking for setup with two buttons YES or NO. Click on YES. After clicking on YES, the below window will appear.
Server Type-Database engine
Server Name- Your PC Name (Eample-GOURI-PC)
Authentication-If you choose Windows authentication, there is no need for login id and password and click on connect
If you choose SQL SERVER Authentication, give login id and password details and click on connect.
After connection has been established, the below window will appear. Right click on Databases and click attach.
After clicking attach, you will see the following window:
Click on ADD. You will see the below screen. Choose your respective database which you want to attach, then Click OK.
After clicking OK, select database which you have added before, then click OK. You are done with copying MDF file to SQL SERVER.
Converting MDF File To Microsoft Access
Go to start, select control panel.
Select Administrative Tools.
Once you select administrative tools, the below window will appear. Double click on Data Source(ODBC).
The below shown window will appear:
Click on ADD button on left. You will see list of drivers available, select SQL SERVER and click finish.
After clicking finish, one window will appear.
Give any random NAME and remember that name for future use. Select your server name from dropdownlist(Example- GOURI-PC).
Click Next Button.
After clicking Next Button, the below window will appear.
If you choose windows NT Authentication, then simply click next.
If you choose SQL SERVER authentication, give LOGIN ID and PASSWORD, then click next.
After clicking next below, choose change the default database to checkbox, then choose the database which you want to convert and click NEXT.
Uncheck the Perform translation for character data and click on FINISH.
Click on Test Data source.
If you see TESTS COMPLETED SUCCESSFULLY, click on OK.
Click on OK. One window will appear. Select the name which you have given in Step 7. Then click on OK.
All programs -> Microsoft Office -> Microsoft Access -> Click on NEW.
It's your choice to give name, then click create on left.
Select EXTERNAL Data from Menu Bar.
Select More -> Click on ODBC Database.
On clicking ODBC Database, the below window will appear, simply click OK.
After clicking OK, the small window appears. Select Machine Data Source -> Select the data source name which you gave in step 7, then click on OK.
After clicking Ok, databases list along with tables will appear. Select appropriate table which you want to convert to Access and click OK.
After clicking OK, the below screen will appear. Click on CLOSE.
After clicking close, your table which you have selected will display at the right side of Access page. Double click on table name, the table data will be displayed. You are done with conversion.