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
