"microsoft.ace.oledb.14.0' provider is not registered on the local machine in sharepoint 2010 server

Question

Hi,

I have custom application page created using VS 2010. it is for importing records from excel (.xls,.xlsx) to SP List.

I am using OLeDb connection to import.

string myConnString = String.Concat(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=filename, 
";Extended Properties=\"Excel 12.0 Xml;HDR=YES\"");

My server Config :

• windows server 2008 (64 bit)
• SharePoint 2010
• MS Office 2010 (32 bit)

I am getting following error

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

how to resolve this? Please help

---

Regards,Akila

Answer 1

Refer the link below

http://social.technet.microsoft.com/Forums/en-US/office2007deploymentcompatibility/thread/cc10d906-0fd8-49ef-a1b0-45814bd70c55

---

Regards, Dharnendra Shah "strong belief is the only way to success"

Answer 2

Hi,
had the same problem.
Finally installing 2007 Office System Driver: Data Connectivity Components did the trick!
Cheers, Stephan

---

To life is christ, to die is gain...

Answer 3

Hola a todos estoy trabajando en una aplicacion en Visual C# 2010, estoy usando plantillas de Excel y realizo la conexion atravez de:

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<connectionStrings>
connectionString="Provider=Microsoft.ACE.OLEDB.14.0;Extended Properties 'Excel 14.0;HDR=YES';Data Source="/>
</connectionStrings>
</configuration>

tengo instalado AccessDatabaseEngine.exe, pero me genera un ERROR:

ex.Message = "Error: El proveedor 'Microsoft.ACE.OLEDB.14.0' no está registrado en el equipo local. 

necesito ayuda

---

slibanez10