excel联接字符串

2012-12-25

excel连接字符串//operate 2003 excelString ConnectionString ProviderMicrosoft.Jet.OLEDB.4.0 +

excel连接字符串
//operate 2003 excel
            String ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + filePath + ";" + "Extended Properties=Excel 8.0;";
            //operate 2007excel
            //String ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" + filePath + ";" + "Extended Properties=Excel 12.0;";