Microsoft.ACE.OLEDB.12.0 提供者並未登錄於本機電腦上

from http://kennycarol.pixnet.net/blog/post/27188076-%E9%8C%AF%E8%AA%A4%E8%A8%8A%E6%81%AF%3A-'microsoft.ace.oledb.12.0'-%E6%8F%90%E4%BE%9B%E8%80%85%E4%B8%A6%E6%9C%AA%E7%99%BB



使用Excel的連接字串如下…
string strExcelConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Server.MapPath("TmpFile\\" + fileName + "" ) + ";Extended Properties='EXCEL 12.0;HDR=Yes;IMEX=1'" ;



Google找了些文章..發現似乎是電腦中..缺少些元件…

有人建議要安裝: Microsoft Access Database Engine 2010 Redistributable
http://www.microsoft.com/downloads/details.aspx?familyid=C06B8369-60DD-4B64-A44B-84B371EDE16D&displaylang=en

裝了沒用…XD….



後來安裝了:
2007 Office system 驅動程式：資料連線元件
http://www.microsoft.com/downloads/zh-tw/confirmation.aspx?displaylang=zh-tw&FamilyID=7554f536-8c28-4598-9b72-ef94e038c891