The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
Good chance you're running the 32-bit 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 a database and select Tasks > Import Data… you automatically start the 32-bit wizard.
Start >> All Programs >> Microsoft SQL Server <version> >> SQL Server <version> Import and Export Data will start the 64-bit version of the wizard.