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)