You must Sign In to post a response.
  • Category: ASP.NET

    Upload excel data in sql using asp.net

    hi every one,

    i upload excel data in sql.is it work in local but when host in server it showing error.
    please solve this i try many times but didn't get.

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

    Thanks and regards
  • #768737
    Hi,

    You need to install Microsoft Office in the server.
    For Microsoft.ACE.OLEDB.12.0 we need to install the this office in the server. This version of DLL will be available in the Microsoft 2010 version,

    Thanks,
    Mani

  • #768738
    Hi

    I am also facing this issue . So that i download and install following url. but still now i facing that issue
    any one guide me. for Microsoft 2010 version not working

    https://www.microsoft.com/en-us/download/details.aspx?id=13255

    Name : Dotnet Developer-2015
    Email Id : kumaraspcode2009@gmail.com

    'Not by might nor by power, but by my Spirit,' says the LORD Almighty.

  • #768739
    Hai Sadiq,
    You need to install the driver for the Microsoft MS Access into the server machine as well and then only it will work. As the driver is not present in the server machine, you are getting this type of error message.
    Hope it will be helpful to you.

    Regards,
    Pawan Awasthi(DNS MVM)
    +91 8123489140 (whatsApp), +60 14365 1476(Malaysia)
    pawansoftit@gmail.com

  • #768749
    Hi Saidq,

    It's looks like bit format issue, you have to install the appropriate drivers suitable for your server machine bit either 32 or 64.

    I guess you are implement the task without knowing the server configurations, whether server supports your implementation or not first check that, because you used all are advanced versions like drivers etc, it may not work in lower version please check those.

    Hope this helps you..

    --------------------------------------------------------------------------------
    Give respect to your work, Instead of trying to impress your boss.

    N@veen
    Blog : http://naveens-dotnet.blogspot.in/

  • #768790
    You need to install particular supporting driver of for the Microsoft MS Access into the server machine to Upload excel data in sql using asp.net .
    Reference for how to upload or import data from excel to SQL Server using asp.net => http://www.aspdotnet-suresh.com/2012/12/c-importupload-data-from-excel-to-sql.html


Sign In to post your comments