Error in Export data from excel to sql server database

Mohammad Danish

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:- [email protected].

Thanks

(Mohd. Danish)

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mohammad Danish9y ago
Any one able to answer this question on c-sharpcorner or not?
Mohammad Danish9y ago
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 Reddy9y ago
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