asp.net +SQL2005 导入Excel时报错无法初始化链接服务器 "(null)" 的 OLE DB 访问接口 "MICROSOFT.JET.OLEDB.4.0" 的数据源对象。
链接服务器"(null)"的 OLE DB 访问接口 "MICROSOFT.JET.OLEDB.4.0" 返回了消息 "未指定的错误"。
找了一下午的错误了。求解,!!!!!
链接服务器"(null)"的 OLE DB 访问接口 "MICROSOFT.JET.OLEDB.4.0" 返回了消息 "未指定的错误"。
找了一下午的错误了。求解,!!!!!
http://blog.csdn.net/lemontec/article/details/1754413
http://blog.csdn.net/lemontec/article/details/1754413这篇文章看过,不是一个问题
http://blog.csdn.net/lemontec/article/details/1754413
这篇文章看过,不是这问题
String strConnectionString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties='Excel 8.0;IMEX=1'", serverpath);//EXCEL2003
OleDbConnection Excel_conn = new OleDbConnection(strConnectionString);
Excel_conn.Open();
string query = "SELECT * FROM [Sheet1$]";//查询Excel字符串
OleDbDataAdapter oleAdapter = new OleDbDataAdapter(query, Excel_conn);
DataSet myDataSet = new DataSet();
Excel_conn.Close();
Excel_conn.Open();
oleAdapter.Fill(myDataSet, "Excel_Sheet1");
Excel_conn.Close();
sqlcon = new SqlConnection(strCon);
for (int i = 0; i <= myDataSet.Tables["Excel_Sheet1"].Rows.Count - 1; i++)
{
string intostr = "insert into teacher_beadroll" + " (name,subject,duty,password)values('" + myDataSet.Tables["Excel_Sheet1"].Rows[i][0].ToString() + "','"
+ myDataSet.Tables["Excel_Sheet1"].Rows[i][1].ToString() + "','" + myDataSet.Tables["Excel_Sheet1"].Rows[i][2].ToString() + "','"
+ myDataSet.Tables["Excel_Sheet1"].Rows[i][3].ToString() + "')";//Excel 插入sql
sqlcon.Open();
sqlcom = new SqlCommand(intostr, sqlcon);
sqlcom.ExecuteNonQuery();//添加
sqlcon.Close();
}