Read .xlsx file from OLEDB (office 2007)
Provider=Microsoft.Jet.OLEDB.4.0;Mode=Read;Data Source=xxx.xls;Extended Properties=Excel 8.0
change to
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=xxx.xlsx;Extended Properties=Excel 12.0
記錄有關於學習的任何心得,目前主要以Microsoft Visual Studio、Sql Server、C#、電腦資訊、軟體應用、程式設計為主!
Provider=Microsoft.Jet.OLEDB.4.0;Mode=Read;Data Source=xxx.xls;Extended Properties=Excel 8.0
change to
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=xxx.xlsx;Extended Properties=Excel 12.0
0 個意見:
張貼留言