Yesterday I was in database team with my friend to import an excel file of 3 million records in a table. While importing we got any error message “The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine”. Here I just want to tell you that we have to do this activity every month and from past 6 months we were doing it successfully until yesterday when we ran into an error “The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine”.
We were in a hurry so we tried another system to import our file but same error come in front of us and in short span we tried three systems but no success. At last I have researched about this error and got to know that we need to install “2007 Office System Driver: Data Connectivity Components”. So I have installed it from this Microsoft link: Click Here on one of our system and then tried importing the excel file into database table and that's it. Yahooooo it was successful. We've spent a lot of time that is why i have decided to write this post so if anyone ran into this problem will solve it by himself after five minutes of searching on Google.
Hope this article will solve your problem and save your time.
No comments:
Post a Comment
Please do not enter spam links.