string strConn = string.Format(“Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=‘Excel 8.0;HDR=Yes;IMEX=1;’”, fileName);
System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(strConn);
if (conn.State != ConnectionState.Open){ conn.Open();}
string sql = “select * from [Sheet1$]”;
System.Data.OleDb.OleDbDataAdapter dataAdapter = new System.Data.OleDb.OleDbDataAdapter(sql, conn);
System.Data.DataSet ds = new System.Data.DataSet();
dataAdapter.Fill(ds, “table12”);
C# DataSet获取Excel导入数据库报错 使用谷歌没问题用IE报错 请教个位大神 错误信息“外部表不是预期的格式”
最新推荐文章于 2023-07-20 11:27:31 发布