批量读取Excel文件给指定数据库

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
using System.Data.SqlClient;

namespace BatchExcelToDatabase
{
    public partial class Frm_Main : Form
    {
        public Frm_Main（）
        {
            InitializeComponent（）;
        }

        private void btn_Select_Click（object sender EventArgs e）
        {
            openFileDialog1.Filter = “Excel文件|*.xls“;//设置打开文件筛选器
            openFileDialog1.title = “选择Excel文件“;//设置打开对话框标题
            openFileDialog1.Multiselect = true;//设置打开对话框中可以多选
            if （openFileDialog1.ShowDialog（） == DialogResult.OK）//判断是否选择了文件
            {
                for

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----
     文件    43621189  2010-08-13 16:42  批量读取Excel文件给指定数据库.exe
     文件         950  2010-06-12 16:18  BatchExcelToDatabase\BatchExcelToDatabase.sln
     文件       20480  2010-11-03 16:52  BatchExcelToDatabase\BatchExcelToDatabase.suo
     文件        4112  2010-11-03 16:52  BatchExcelToDatabase\BatchExcelToDatabase\BatchExcelToDatabase.csproj
     文件       14937  2010-06-25 20:28  BatchExcelToDatabase\BatchExcelToDatabase\Frm_Main.cs
     文件       16310  2010-06-13 09:10  BatchExcelToDatabase\BatchExcelToDatabase\Frm_Main.designer.cs
     文件        6017  2010-06-13 09:10  BatchExcelToDatabase\BatchExcelToDatabase\Frm_Main.resx
     文件         504  2010-06-13 08:33  BatchExcelToDatabase\BatchExcelToDatabase\Program.cs
     文件       19968  2010-11-03 16:52  BatchExcelToDatabase\BatchExcelToDatabase\bin\Debug\BatchExcelToDatabase.exe
     文件       40448  2010-11-03 16:52  BatchExcelToDatabase\BatchExcelToDatabase\bin\Debug\BatchExcelToDatabase.pdb
     文件       14328  2010-06-13 08:27  BatchExcelToDatabase\BatchExcelToDatabase\bin\Debug\BatchExcelToDatabase.vshost.exe
     文件         490  2009-06-11 05:14  BatchExcelToDatabase\BatchExcelToDatabase\bin\Debug\BatchExcelToDatabase.vshost.exe.manifest
     文件       65536  2007-10-10 09:48  BatchExcelToDatabase\BatchExcelToDatabase\bin\Debug\dao.dll
     文件      997992  2007-10-10 09:48  BatchExcelToDatabase\BatchExcelToDatabase\bin\Debug\Microsoft.Office.Interop.Access.dll
     文件     1100392  2007-10-10 09:48  BatchExcelToDatabase\BatchExcelToDatabase\bin\Debug\Microsoft.Office.Interop.Excel.dll
     文件        3199  2010-11-03 16:52  BatchExcelToDatabase\BatchExcelToDatabase\obj\Debug\BatchExcelToDatabase.csproj.FileListAbsolute.txt
     文件         850  2010-11-03 16:52  BatchExcelToDatabase\BatchExcelToDatabase\obj\Debug\BatchExcelToDatabase.csproj.GenerateResource.Cache
     文件       19968  2010-11-03 16:52  BatchExcelToDatabase\BatchExcelToDatabase\obj\Debug\BatchExcelToDatabase.exe
     文件         180  2010-11-03 16:52  BatchExcelToDatabase\BatchExcelToDatabase\obj\Debug\BatchExcelToDatabase.Frm_Main.resources
     文件       40448  2010-11-03 16:52  BatchExcelToDatabase\BatchExcelToDatabase\obj\Debug\BatchExcelToDatabase.pdb
     文件         180  2010-11-03 16:52  BatchExcelToDatabase\BatchExcelToDatabase\obj\Debug\BatchExcelToDatabase.Properties.Resources.resources
     文件       14664  2010-06-13 09:05  BatchExcelToDatabase\BatchExcelToDatabase\obj\Debug\ResolveAssemblyReference.cache
     文件        1372  2010-06-12 16:18  BatchExcelToDatabase\BatchExcelToDatabase\Properties\AssemblyInfo.cs
     文件        2890  2010-06-12 16:18  BatchExcelToDatabase\BatchExcelToDatabase\Properties\Resources.Designer.cs
     文件        5612  2010-06-12 16:18  BatchExcelToDatabase\BatchExcelToDatabase\Properties\Resources.resx
     文件        1105  2010-06-12 16:18  BatchExcelToDatabase\BatchExcelToDatabase\Properties\Settings.Designer.cs
     文件         249  2010-06-12 16:18  BatchExcelToDatabase\BatchExcelToDatabase\Properties\Settings.settings