unable to import xlsx file in sql2014

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

September 4th, 2015 5:54pm

You would need to install the driver for excel

https://social.msdn.microsoft.com/Forums/en-US/1d5c04c7-157f-4955-a14b-41d912d50a64/how-to-fix-error-the-microsoftaceoledb120-provider-is-not-registered-on-the-local-machine?forum=vstsdb

https://social.technet.microsoft.com/Forums/office/en-US/cc10d906-0fd8-49ef-a1b0-45814bd70c55/microsoftaceoledb120-provider-is-not-registered-on-the-local-machine?forum=officesetupdeploylegacy

Free Windows Admin Tool Kit Click here and download it now
September 4th, 2015 7:03pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics