Hello All,
Im trying to read an excel file & upload its data to sql server. locally the application is working fine but after I deploy on server, it gives error "The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine"
I follwed The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. and did all steps but still the same error.
My windows server is 2008R2 64 bit and office 2010 32 bit. I also tried to publish my project in x86 but still no success.
If anyone face this issue before please let me know your suggestions
Thanks