Forum Discussion

Copper Contributor

Jun 07, 2017

read excel 2016 with c#

I have reciently installed Office 2016, and tried to read an Excel spreadsheet programically using C#. I get the following error "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the lo...

excel

Logaraj Sekar

Iron Contributor

Jun 08, 2017

Try downloading and installing the Microsoft.ACE.OLEDB.12.0 Data Provider that is part of the Microsoft Access Database Engine. Link: https://www.microsoft.com/en-us/download/details.aspx?id=13255

The page here give more information about the process:

https://social.technet.microsoft.com/wiki/contents/articles/24236.importing-an-excel-spreadsheet-into-a-sql-server-database.aspx