Excel导入数据到SqlServer中提示：定义了过多字段？

Question

如题   Excel导入数据到SqlServer中提示：定义了过多字段？源码：// fileName  文件名//savePath  路径 DataSet ds = null;            try            {                string myString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + savePath + fileName + ";Extended Properties='Excel 8.0;HDR=No;IMEX=1'";                OleDbConnection oconn = new OleDbConnection(myString);                oconn.Open();                ds = new DataSet();                OleDbDataAdapter oda = new OleDbDataAdapter("select * from [Sheet1$]", oconn);                oda.Fill(ds);                oconn.Close();            }            catch (Exception ea)            {                My.ClientScript.Alert(this, "提供的文档错误：" + ea.Message);            }            return ds;

Answer 1

你这种做法，导入过来的DataTable，最起码要遍历它，再组装为Insert进去，这样保险。

Answer 2

如果表头是一一对应的话,楼主检查下excel除数据区域之外是否有空白的表格...