2016年2月25日 星期四

C# Read excel with error message that The "Microsoft.ACE.OLEDB.12.0" provider is not registered on the local machine

English
========================================================================
I'm try to develop the tool with excel read/write. I get some error message like "The "Microsoft.ACE.OLEDB.12.0" provider is not registered on the local machine". The error message like below picture.



I google and find out the way to fix it.

1. Download the "Microsoft Access Database Engine 2010 Redistributable"
    Download link: Download

2. Download the "2007 Office System Driver: Data Connectivity Components"
    Download link: Download

3. Reboot the PC.



中文
========================================================================
最近在撰寫 read/write excel 檔案的程式,程式執行時,出現 "The "Microsoft.ACE.OLEDB.12.0" provider is not registered on the local machine" 錯誤訊息,如下圖


經過查驗,發現以下解決方法可行。

1. 下載 "Microsoft Access Database Engine 2010 可轉散發套件"
    下載連結: Download

2. 下載 "2007 Office system 驅動程式:資料連線元件"
    下載連結: Download

3. 重開機即可解決此問題

沒有留言:

OS Operating System 作業系統 恐龍書 筆記分享

發現一個作業系統說明的網站, 對於 process vs thread, semaphore vs mutex, deadlock 說明很詳細, 有興趣的人可以去以下的網頁逛逛。 附上網址連結: link   link2