小弟要将EXCEL表格中的数据导入到MYSQL数据库中，求解该怎么写，导出已经可以了，但是导入的时候不知道怎么弄，怎么将EXCEL表格中的数据提取出来，注意是MYSQL不是SQLSERVER
------解决方案--------------------------------------------------------
- C# code
public DataSet ds(){string type2 = FileUpload1.FileName; var type3 = type2.Substring(type2.LastIndexOf('.')); if(type3.Equals(".xls") || type3.Equals(".xlsx")) { string newName = Server.MapPath("..//App_Data//Uploads//") + DateTime.Now.ToString("hhmmss") + ".xls"; FileUpload1.SaveAs(newName); string connStr = string.Empty; if (type3.Equals(".xlsx")) { connStr = "Provider=Microsoft.Ace.OleDb.12.0;Data Source=" + newName + ";Extended Properties='Excel 12.0 Xml; HDR=YES; IMEX=1'"; } else if (type3.Equals(".xls")) { connStr = "Provider=Microsoft.Jet.OleDb.4.0;" + "data source=" + newName + ";Extended Properties='Excel 8.0; HDR=YES; IMEX=1'"; } OleDbConnection conn = new OleDbConnection(connStr); if (conn.State.ToString() == "Closed") { conn.Open(); } DataTable dt = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null); var tableName = dt.Rows[0][2].ToString().Trim(); var str1 = string.Format("Select * from [{0}]", tableName); OleDbDataAdapter oda = new OleDbDataAdapter(str1, conn); DataSet ds = new DataSet(); oda.Fill(ds); conn.Close(); File.Delete( newName ); return ds}
------解决方案--------------------------------------------------------
把数据集 插入数据库 应该会了吧..