Import Export Wizard errors on Excel source – ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine
Quick problem / solution today.
If you open the Import Export wizard and try to import an Excel workbook as a source (Fun fact you have to run the wizard in 32bit to get Excel as an option!). You get the error below:
Download the Microsoft Access Database Engine 2010 Redistributable from here: https://www.microsoft.com/en-gb/download/details.aspx?id=13255
Note: you need the 32bit install not the 64bit!
close and reopen the import export wizard. and it should now work.