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.
https://www.microsoft.com/en-gb/download/details.aspx?id=13255
Note: I am on a 64 bit system and I am using 64 bit verions of excel and sql.
Our systems use 32-bit Office on 64-bit versions, so I am unable to test your scenario, however from the community it does look like the 64-bit Office drivers do not help in a lot of cases. The 2007 Office drivers have helped a lot of people.