The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine

when you import excel sheet data into sql server. you might encounter this error "The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine"

the main reason of this cause is that the your application is running in 64 bit machine.


there are two approach to solve this issue.

1. change your visual studio build platform target to X86 and deploy your applicaiton again.




























2. change Enable 32 bit applicaiton property to be true in the application pool advance setting section.