excel导入出现错误,不支持关键字: “provider”。
- C# code
string sqlstr;sqlstr = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + strpath + ";" + "Extended Properties=Excel 8.0;";SqlConnection conn = new SqlConnection(sqlstr);SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM [Sheet1$]",conn);adapter.Fill(ds,"excel");
我的vs是2005,excel貌似是2003的,请问要改什么?
[解决办法]
应该是OleDbConnection