none
"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

    Monday, April 23, 2012 10:50 AM

Answers

  • 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"

    • Marked as answer by Shimin Huang Friday, May 04, 2012 7:22 AM
    Monday, April 23, 2012 11:23 AM

All replies

  • 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"

    • Marked as answer by Shimin Huang Friday, May 04, 2012 7:22 AM
    Monday, April 23, 2012 11:23 AM
  • 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...

    Saturday, May 12, 2012 9:15 AM
  • 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

    Wednesday, September 05, 2012 2:19 PM