Error in Export data from excel to sql server database

Question

Dear Developers I am getting error ( The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. ) in exporting data from excel sheet to sql server database using sql bulk copy. But this error I can fix on set  Enable 32-Bit Applications = 'true'  in Application Pool  but I don't want it to set true. Without set true this property can we export data excel to database. Please share your solution for this problem and revert me asap. Email Id:- danishdotnet@gmail.com. Thanks (Mohd. Danish)

Mohammad Danish · Answer

Any one able to answer this question on c-sharpcorner or not?

Mohammad Danish · Answer

These link is not useful for me. If you have diffrent way to do this then tell me. and second link referance I have already clear in question description that I don't want (Enable 32-Bit Application = true)

Samatha Reddy · Answer

please refer these links it may usefull for you http://stackoverflow.com/questions/6649363/microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine https://www.mikesdotnetting.com/article/280/solved-the-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine