C#编程：Excel数据导入数据库详解

本文先将Excel文件转换成DataTable，然后再循环将记录插入到数据库表中，这种方式可以任由程序员来选择将哪列数据导入到数据表的哪个字段中

DataTable table =new DataTable();

//数据绑定到datagridview1
private void button1_Click(object sender, EventArgs e) {
            System.Windows.Forms.OpenFileDialog fd = new OpenFileDialog();
            if (fd.ShowDialog() == DialogResult.OK)
            {
                string fileName = fd.FileName;
                bind(fileName);
            }
        }

        private void bind(string fileName) {
            string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +
                 "Data Source=" + fileName + ";" +
                 "Extended Properties='Excel 8.0;HDR=Yes;IMEX=1'";
            OleDbDataAdapter da = new OleDbDataAdapter("SELECT *  FROM [Sheet1$]", strConn);
            DataSet ds = new DataSet();
            try
            {
                da.Fill(ds);
                dt = ds.Tables[0];
                this.dataGridView1.DataSource = dt;           
            }
            catch (Exception err)
            {
                MessageBox.Show("操作失败！"+err.ToString());
            }