(C#) - 上傳office檔案遇到provider尚未註冊

此篇記錄一下使用C#上傳excel檔案會遇到

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

:解決方式:

-依照office版本下載
Microsoft Office Access database engine 2007
Microsoft Access Database Engine 2010

-IIS設定
Application Pools
Locate the Enable 32-bit Applications entry and change False to True:


後續
- 指定上傳路徑資料夾須建立並打開權限


參考資料
https://stackoverflow.com/questions/6649363/microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine

https://www.mikesdotnetting.com/article/280/solved-the-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine