Import Microsoft Access .accdb File to MS SQL Server

Steps to Import Microsoft Access .accdb File to MS SQL Server

1. Open MS SQL Server Import and Export Wizard.
2. For “Data Source” choose “Microsoft Office 12.0 Access Database Engine OLE DB Provider”.
3. Click “Properties” enter the location of the .accdb file in the “Data Source” field.
4. Under login information, choose a blank username and be sure to check “Blank Password”.
5. Test the connection. If it works, click OK.
6. For the “Data Destination” choose “Microsoft OLE DB Provider for SQL Server”.
7. Enter the MS SQL server name or choose from the dropdown menu.
8. Enter your SQL credentials and select the database you wish to import the data to, the database should show up in the dropdown menu if your MS SQL info is correct.
9. Select “Copy data from one or more tables or views”.
10. Select the tables you want copied and edit the mappings if needed.
11. Continue through the wizard and hit finish to begin the import.

Ref : http://serversideguy.com/2014/02/05/import-microsoft-access-accdb-file-to-ms-sql-server/ 

The page you are requesting cannot be served because of the extension configuration

Scenario:

I was getting the below error message when trying to run my application having .svc file. 

HTTP Error 404.3 - Not Found The page you are requesting cannot be served because of the extension configuration. If the page is a script, add a handler. If the file should be downloaded, add a MIME map.

Screenshot of the error page: 



Solution 1:

Please follow the below two steps on IIS 8.0.

Step 1. Add new MIME type 

1. Extension: .svc, MIME type: application/octet-stream

Step 2: Add new HttpHandler

1. Request path: *.svc, Type: System.ServiceModel.Activation.HttpHandler, Name: svc-Integrated

Step 3: Restart IIS

Solution 2:

In Windows 7 and earlier, run aspnet_regiis -i 
Note: but this command seems to have been deprecated in Windows 8 yielding response This option is not supported on this version of the operating system. (...).