I am trying to use the sql management studio import wizard to import some tables from excel.
I have SQL server express 2016 installed and Excel 2016 (e3) (see image of version below).
Everytime I try to import from excel I get the following error msg (see image below).
So far I have tried installing Microsoft Access Database Engine 2010 Redistributable
after reading suggestions in blogs etc. (link to download below). However I am still getting the same error msg.
Note: I am on a 64 bit system and I am using 64 bit verions of excel and sql.