I have website and from my website admin console there is an option to upload excel file. Once you click on submit button the data will be loaded into my database.but now i am facing an issue while uploading excel file. It is showing error message "microsoft.ace.oledb.12.0' provider is not registered on the local machine". please let me know the solution to resolve the issue. I am using SQLServer 2008 at my local machine.
Your solution might be here
At the given link saying to install the
2007 Office System Driver: Data Connectivity Components. On my local machine its already installed and my project is working fine. So how can we install this on web hosting.
I'm also facing the same issue. Spoke to Go Daddy Technical Support team regarding this. They don't have any answer for this.
Can any one help on this. if there is any other way of resolving the issue.
I have got the same issue. Even after knowing the solution that an exe should be installed from https://www.microsoft.com/en-us/download/details.aspx?id=13255 , they are not able to help us. I feel like i am dead locked.