Fixed "the microsoft ace oledb 12.0 provider is not registered" error when import data from Excel spreadsheet in SQL Server 2012

I try to import a Excel 2013 spreadsheet to SQL Server 2012 Database and received above error message. I installed below component "2007 Office System Driver: Data Connectivity Components" (https://www.microsoft.com/en-us/download/details.aspx?id=23734) and then try the import again. Works fine!

Comments

Post a Comment

Popular posts from this blog

Top JavaScript courses helping you develop SPFx webPart with ReactJS and AngularJS

Image
As SharePoint 2016 is launched and the SharePoint Framework was announced on 4th of May,  for a SharePoint developer, these are the technologies that you should learn in the next months in order to be prepared to the new framework. They are AngularJS, ReactJS, Node.js and TypeScript. I shared those best online courses from "Udemy.com" in here. Learn anytime, anywhere, on most devices. Each course comes with a 30-day money-back guarantee. Course : Sharepoint: SPFx Development Model - It's providing clear instructions on this new SPFx framework. It delivers an example of full development workflow using Knockout.js JavaScript framework and PnP helper code. Instructor: OLEG RUMIANCEV is a full-time SharePoint ninja currently living in Biddulph, United Kingdom. His interests range from Microsoft and SharePoint to AI, and inspirational TED talks. ReactJS - React is straight JavaScript and more smaller compare with Angular JS. It's emerging in an ecosystem of...
Read more

Effective LLM Prompting skills

Apply best practices for crafting effective prompts to LLM are key for effective prompting to LLM . Here are the best practices. Role assignment: specifying a role for the LLM lead to a more helpful response. You can even a pply multiple roles to LLM Specificity and context: by providing context about your role and the situation and highlighting your specific concerns, you're guiding the LLM to provide specific and relevant information. Feedback to LLM:  You can effectively analyze your prompt based on the LLM response, and identify weaknesses, and points out the targeted improvements for better prompt. For example, you are a software developer and want LLM to review and debug the code errors. Your prompt can be: You are a senior Python developer and tester, I'm a junior Python developer working on a program to calculate daily interest rates. I'm encountering an error when running my code. Could you help me debug it? Here's a snippet of the code: "..."', a...
Read more

How to replace the OOTB SharePoint Help with your custom help page

Image
If you want to replace the Out of Box SharePoint Help with your custom help page when people click on "?" icon on the top right corner on the SharePoint Portal 2013, then you can use below jQuery in HTML master page. The sample screenshot is as following. You need to reference to the "jquery.SPServices-2014.02.js" file firstly.     var currentSite=$().SPServices.SPGetCurrentSite();   /*Replace ms-help element onclick event*/   $("#ms-help>a").attr("onclick","abc");   /*Replace below "Pages/PortalHelp.aspx" with your actual custom Help page location*/   $("#ms-help>a").attr("href",currentSite+"/Pages/PortalHelp.aspx");     $('#ms-help>a').click(function(){               window.location.href=currentSite+"/Pages/PortalHelp.aspx";     }); This post is part of my BI Portal project . If you are interested to know more how I customized a Out Of Box Bu...
Read more