Is there any 64 bit driver for excel? RRS feed

  • Question

  • When I am upload an excel file in 32 bit using jet provider, the web application is working fine , the data gets inserted into daatabase from excel. but when I deploy application in 64 bit it is showing error . Is there any 64 bit driver to upload excel file. (I have tried installing 2007 Office System Driver: Data Connectivity Components and 64 bit -Microsoft Access Database Engine 2010 Redistributable )

    I have tried using Jet OLEDB as well as AceOLEDB. But it doesnt work.

    The connection strings are as below



    "Provider=Microsoft.Jet.OLEDB.4.0;Mode=Read;Extended Properties='Excel 8.0;HDR=Yes;';Data Source={0}"



    Provider=Microsoft.ACE.OLEDB.12.0;Mode=Read;Extended Properties=Excel 12.0;HDR=Yes;';Data Source={0}".

    Please let me know how this can be resolved without using the 32 bit application pool setting

    Tuesday, February 15, 2011 11:54 AM