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

React Native error - Cannot find module 'metro-react-native-babel-preset'

Image
I created a React native app using "react-native init <App Name> " but received below error when try to run it in Simulator: Cannot find module 'metro-react-native-babel-preset' I resolved the error by adding below line under "dependencies" in package.json.     "@babel/runtime": "^7.0.0-beta.55"  Run "npm i", and then run the app successfully. :) Further Study     I had been studied the online course " The Complete React Native and Redux Course ", it gave me the clear explanation and instruction with step by step procedures to learn the core knowledge to build React components for mobile devices. It's suitable for all levels. The course has sample code and completed projects in gitHub.com. Instructor : Stephen Grider -  Engineering Architect, Stephen Grider has been building complex Javascript front ends for top corporations in the San Francisco Bay Area.
Read more

Some tipts to Embeded PowerBI report in a Azure Web App

I follow the sample " https://github.com/guyinacube/PowerBI-Developer-Samples " - "Apps Owns Data" to allow external users to access internal PowerBI data. I got error 'Unauthorized' when try to access it by the given report group Id. I checked with the BI guys that the workspace in PowerBI is created as public or private mode. It should be public mode. In addition, you need to grant relevant permissions to the app registered in the Azure AD. Do this with a AZure Admin account. Refer to below lessons. https://community.powerbi.com/t5/Developer/Power-BI-Embedded-authentication-error/td-p/197670 https://docs.microsoft.com/en-us/azure/active-directory/develop/active-directory-authentication-scenarios
Read more

"allowed_paths" in Gradio

 I need to open a video file under a Gradio chatbot app via URL: < siteURL >/file={ output_video_filename }. By default, Gradio not allows to open a file under the app folder, and so I added "allowed_paths" in "launch()" function.  Sample code as below. demo.launch(server_name="127.0.0.1", server_port=8000, allowed_paths=["output_video.mp4"])
Read more