Pretend for a second that you are an application developer, developing in VB.Net, and you find yourself needing to work with an Office-based data file (like Access or Excel). In this most of time we get these error
The ‘Microsoft.ACE.OLEDB.12.0′ provider is not registered on the local machine.
This will happen only because of data connectivity components missing, it will automatically install with microsoft office product. If any one don’t want to install office product but should process the excel and access file. then the ultimate solution is install the following components
Most of the time it work fine for me.. Do you have any issue please let me know.. Cheers..