Excel导入数据库最好的办法？

Question

Excel导入数据库最好的办法？怎么导入?

Answer 1

 但是这种方法需要在服务器安装Office中的某些部分

Answer 2

使用OLEDB驱动，直接把excel文件当作数据库进行处理最好。

Answer 3

我做过，你试试：http://blog.csdn.net/chenpeng0118/article/details/5685948private void dgv_MouseClick(object sender, MouseEventArgs e)
        {
            int index = dgv.CurrentCell.RowIndex;
            txtPOName.Text = dgv[0, index].Value.ToString();
            txtMaterialNO.Text = dgv[1, index].Value.ToString();
            txtMaterialNum.Text = dgv[4, index].Value.ToString();            txtMaterialName.Text = dgv[2, index].Value.ToString();
            txtMaterialType.Text = dgv[3, index].Value.ToString();
            txtMaterialPrice.Text = dgv[5, index].Value.ToString();
            txtMaterialSize.Text = dgv[6, index].Value.ToString();
            txtUnit.Text = dgv[7, index].Value.ToString();
            txtRe.Text = dgv[11, index].Value.ToString();
        }        private void tsInputPO_Click(object sender, EventArgs e)
        {
            DataSet ds = new DataSet();
            string strCon = " Provider = Microsoft.Jet.OLEDB.4.0 ; " + "Data Source =" + txtFilePath.Text.Trim() + ";Extended Properties=Excel 8.0";
            OleDbConnection myConn = new OleDbConnection(strCon);
            string sql = "Select * FROM [Sheet1$]";
            try
            {
                myConn.Open();
                OleDbDataAdapter oda = new OleDbDataAdapter(sql, myConn);                oda.Fill(ds, "[Sheet1$]");
                myConn.Close();            }
            catch (Exception ex)
            {                MessageBox.Show(ex.Message);
            }            //这里的连接用来将数据写入SQLDB            
            string connectionString = ConfigurationManager.ConnectionStrings["WMS_StrConnection"].ConnectionString;            
            SqlConnection con = new SqlConnection(connectionString);
            string sqlGetAllDB = "select * from PO";
            SqlDataAdapter daAllDB = new SqlDataAdapter(sqlGetAllDB, con);
            DataSet dsAllDB = new DataSet();
            DataGrid mygrid = new DataGrid();
            mygrid.BeginInit();
            mygrid.Location = new System.Drawing.Point(10, 240);
            mygrid.Width = 1020;
            mygrid.Height = 300;
            this.Controls.Add(mygrid);
            mygrid.EndInit();
            mygrid.SetDataBinding(ds, "[Sheet1$]");            try
            {
                int num = ds.Tables[0].Rows.Count;
                for (int i = 0; i < num; i++)
                {
                    string ch1 = mygrid[i, 0].ToString();
                    string ch2 = mygrid[i, 1].ToString();
                    string ch3 = mygrid[i, 2].ToString();                    string ch4 = mygrid[i, 3].ToString();
                    string ch5 = mygrid[i, 4].ToString();
                    string ch6 = mygrid[i, 5].ToString();                    string ch7 = mygrid[i, 6].ToString();
                    string ch8 = mygrid[i, 7].ToString();
                    string ch9 = mygrid[i, 8].ToString();                    string ch10 = mygrid[i, 9].ToString();
                    string ch11 = mygrid[i, 10].ToString();
                    string ch12 = mygrid[i, 11].ToString();                    string ch13 = mygrid[i, 12].ToString();
                    string ch14 = mygrid[i, 13].ToString();
                    string ch15 = mygrid[i, 14].ToString();                    string strii = "select * into from" + ds.Tables[0].TableName;
                    string strsql = "insert into PO values('" + ch1 + "','" + ch2 + "','" + ch3 + "','" + ch4 + "','" + ch5 + "','" + ch6 + "','" + ch7 + "','" + ch8 + "','" + ch9 + "','" + ch10 + "','" + ch11 + "','" + ch12 + "','" + ch13 + "','" + ch14 + "','" + ch15 + "')";
                    con.Open();
                    System.Data.DataTable dt = new System.Data.DataTable("PO");
                    SqlDataAdapter da = new SqlDataAdapter(strsql, con);
                    da.Fill(dt);
                    this.lblMessage.Text = "数据导入成功!";
                    lblMessage.ForeColor = Color.Green;
                    con.Close();
                    BindDGV();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("失败！");
            }
        }