Error: The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.
I got this error when I tried to run my .NET application into VS 2010 with 64 bit OS/machine, to resolve this issue we have to forcefully set application setting to run this application for 32 bit, to do that please follow the steps below
1) Right click on the project and click on the properties
2) Go to the Build tab
3) Set Platform target from "Any CPU" to x86
4) Now run your application again, you will not get this error again.