Thursday, August 14, 2014

How to import Excel file to a database in MSSQL Management Studio 2012

How to Import Excel file to a database.

Initial Steps:

Select a database and select a Import operation, you will find this after you navigate to 

Select datasource as Microsoft Excel and give excel file to it.

When you import an Excel file to your Database then sometimes this error might come.

'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

You will need to install the driver for Access. Please find the download file and follow the
step provided.

Step 1:

Step 2:

Step 3:

Step 4:

Step 5:

In this way you can import an Excel from MSSQL import wizard.

No comments:

Post a Comment