How to import excel through SQL Import Export wizard..

Ever got that annoying error?

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

Note: Cause for this issue: You are using 64Bit version of the Import and Export Wizard and want to import an xlsx-file.  

You could solve it by saving the file as an xls-file (the Excel 97-2003 Workbook version). Or you can also run the 64-bit version of the wizard.

If you right click on required database and select Tasks > Import Data… wizard will automatically start  in 32-bit wizard. and then you can select your excel.

But if you will find error at the time of excel file selection or related with that then you need to save you Xlsx file into xls format (Compatible mode of excel "97-2003 workbook").

It will solve your issue.

Start >> All Programs >> Microsoft SQL Server <version> >> SQL Server <version> Import and Export Data will start the 64-bit version of the wizard.