使用.Net将Excel数据批量导入数据库的实现方法

      //导入数据
        public void ExecleDs()
        {
            //string sheetName = "IMSI";
            bool seccse;
            DialogResult filenameurl = openFileDialog1.ShowDialog();
            if (filenameurl != DialogResult.OK)
                return;
            string IsXls = System.IO.Path.GetExtension(openFileDialog1.FileName).ToString().ToLower();
            if (IsXls != ".xls")
            {
                toolStripStatusLabel1.Text="请选择Excel文件！";
                return;
            }
            DataSet ds = new DataSet();
            DataTable dt = new DataTable();
            dt.TableName = "Sheet1";
            dt.Columns.Add("IMSI", typeof(string));
            dt.Columns.Add("MSISDN", typeof(string));
            dt.Columns.Add("TrainNumber", typeof(string));
            dt.Columns.Add("TrainRunningNumber", typeof(string));
            ds.Tables.Add(dt);
            //string strConn = "Provider=Microsoft.JET.OLEDB.4.0;"+"Data Source=" + filenameurl + ";Extended Properties=Excel 8.0;";
            string connStr = string.Format(" Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source ={0};Extended Properties=Excel 8.0", openFileDialog1.FileName);
            OleDbConnection conn = new OleDbConnection(connStr);
            conn.Open();
            OleDbDataAdapter odda = new OleDbDataAdapter("select * from [Sheet1$]", connStr);
            odda.Fill(ds, "Sheet1");
            int rowCount = ds.Tables[0].Rows.Count;
            DataRow[] dr = ds.Tables[0].Select();