1导入命名空间：using System.Data.OleDb;
//excel数据源 path为excel的路径
        private DataTable GetDataFromExcelWithAppointSheetName(string path)
        {
            //连接串
            string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + path + ";" + "Extended Properties=Excel 8.0;";
            OleDbConnection conn = new OleDbConnection(strConn);

            conn.Open();

            //返回Excel的架构，包括各个sheet表的名称,类型，创建时间和修改时间等
            DataTable dtSheetName = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null,null, null, "Table" });

            //包含excel中表名的字符串数组
            string[] strTableNames = new string[dtSheetName.Rows.Count];
            for (int k = 0; k < dtSheetName.Rows.Count; k++)
            {
                strTableNames[k] = dtSheetName.Rows[k]["TABLE_NAME"].ToString();
            }

            OleDbDataAdapter myCommand = null;
            DataTable dt = new DataTable();

            //从指定的表明查询数据,可先把所有表明列出来供用户选择
            string strExcel = "select * from [" + strTableNames[0] + "]";
            myCommand = new OleDbDataAdapter(strExcel, strConn);
            dt = new DataTable();
            myCommand.Fill(dt);
            conn.Close();
            conn.Dispose();

            //this.GridView1.DataSource = dt;
            //this.GridView1.DataBind();

            return dt;
        }


2 //插入数据 dt为获取的excel，dataname为数据库名字
        protected bool InsertSQLServer(DataTable dt, string dataname)
        {
                 

          string strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=文件路径\文
名.mdb";//无数据库名连接
            string strTest = "Users";//表的名字
            try
            {
                SqlConnection con = new SqlConnection(strCon);//创建数据库
                con.Open();
                string strSQL = "IF NOT EXISTS(SELECT name FROM sys.databases WHERE name=N'" + dataname + "') CREATE DATABASE [" + dataname + "]";
                SqlCommand command = new SqlCommand(strSQL, con);
                command.ExecuteNonQuery();

                //创建数据库表
                strSQL = "USE[" + dataname + "] IF NOT EXISTS(SELECT * FROM sys.objects WHERE object_id=OBJECT_ID(N'[DBO].[" + strTest + "]') AND type in (N'U')) CREATE TABLE " + strTest + " (";
                string strColumn = string.Empty;
                for (int i = 0; i < dt.Columns.Count; i++)
                {
                    strSQL += "[" + dt.Columns[i].ColumnName + "] [nvarchar](256),";
                    strColumn += dt.Columns[i].ColumnName + ",";
                }
                strSQL += " )";
                SqlCommand newcom = new SqlCommand(strSQL, con);
                newcom.ExecuteNonQuery();

                //插入数据
                strColumn = strColumn.Substring(0, strColumn.Length - 1);
                for (int i = 0; i < dt.Rows.Count; i++)//将i=0改为i=1可以再第二行加中文注释
                {
                    strSQL = "USE[" + dataname + "] Insert into " + strTest + " (" + strColumn + ") values (";
                    for (int k = 0; k < dt.Columns.Count; k++)
                    {
                        strSQL += "'" + dt.Rows[i][k].ToString() + "',";
                    }
                    strSQL = strSQL.Substring(0, strSQL.Length - 1);
                    strSQL += ")";
                    SqlCommand insertCom = new SqlCommand(strSQL, con);
                    insertCom.ExecuteNonQuery();
                    //加一个session["no"]=dt.Rows.Count.toString();可以知道导入几条（注意要减1）
                }
                return tr