The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

02/08/2013 17:40

When using OleDb12 provider to read excel file from powershell, following error occured.

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

Even Office 2010 was installed, script was not working.

 

Download following installer (even if its for 2007 Office, it works also with 2010)
https://www.microsoft.com/en-us/download/confirmation.aspx?id=23734