Mohammad Danish

Mohammad Danish

  • NA
  • 14
  • 600

Error in Export data from excel to sql server database

Apr 5 2017 5:53 AM
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) 

Answers (3)