Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
3
Reply
Error in Export data from excel to sql server database
Mohammad Danish
Apr 5 2017 5:53 AM
188
Reply
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)
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
3
)
Next Recommended Forum
Drag drop shapes into canvas and make them resizeable
Insert table in rdlc report using programatically