Excel2007 和 Excel2010 的连接字符串为:
<connectionStrings > <add name="ConnectionStrings" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\Excel.xlsx;Extended Properties='Excel 12.0;HDR=YES IMEX=1;'"/> </connectionStrings>
Excel2007 和 Excel2010 的连接字符串为:
<connectionStrings > <add name="ConnectionStrings" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\Excel.xlsx;Extended Properties='Excel 12.0;HDR=YES IMEX=1;'"/> </connectionStrings>