使用C#将Excel数据导入SQL数据库

 private void button1_Click(object sender, EventArgs e)
        {
            OpenFileDialog up = new OpenFileDialog();
            up.Filter = "*.xls|*.XLS";

            if (up.ShowDialog() == DialogResult.OK)
            {
                string file = up.FileName;
                DataTableToDB(file);

            }


        }
        /// <summary>
        /// 查询excel 里面的数据
        /// </summary>
        /// <param name="strExcelFileName"></param>
        /// <param name="strSheetName"></param>
        /// <returns></returns>
        public static DataTable ExcelToDataTable(string strExcelFileName, string strSheetName)
        {
            string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + strExcelFileName + ";" + "Extended Properties='Excel 5.0;HDR=False;IMEX=1'";

            DataSet ds = new DataSet();
            string sql = "select   *   from   [" + strSheetName + "$]";

            using (OleDbConnection con = new OleDbConnection(strConn))
            {
                con.Open();