Quick problem / solution today.

Problem

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:

Capture

Solution

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.

Advertisements