I Am trying to import xlsx file using import wizard in sql 2014 and I am getting this error
The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine.
I then installed Microsoft Access Database Engine 2010 Redistributable from this link http://www.microsoft.com/en-us/download/details.aspx?id=13255
and still getting the same error.
My data source is Microsoft Excel and excel version is Microsoft Excel 2007 and when I click next I get this error The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine.
I am not sire what to do at this point, I tried searching on the net but it was not helpful
Thanks