星期一, 3月 12, 2012

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

0 個意見: