ADO.NET读取Eexcel数据!

//添加命名空间
using System.Data.OleDb;

//获取Excel里第一个工作表里的数据
public DataSet GetExcelData()
    {
        // 连接字符串
        string oleDBConnString = String.Empty;
        oleDBConnString = "Provider=Microsoft.Jet.OLEDB.4.0;";
        oleDBConnString += "Data Source=";
        oleDBConnString += this.m_excelPath;
        oleDBConnString += ";Extended Properties=Excel 8.0;";

        OleDbConnection oleDBConn = null;
        OleDbDataAdapter oleAdMaster = null;
        DataTable tableName = new DataTable(); ;
        DataSet ds = new DataSet();
        try
        {
            oleDBConn = new OleDbConnection(oleDBConnString);
            oleDBConn.Open();
            tableName = oleDBConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);

            if (tableName != null && tableName.Rows.Count > 0)
            {
                tableName.TableName = m_tableName.Rows[0]["TABLE_NAME"].ToString();
            }
            string sqlMaster;
            sqlMaster = " SELECT *  FROM [" + m_tableName + "]";
            oleAdMaster = new OleDbDataAdapter(sqlMaster, oleDBConn);
            oleAdMaster.Fill(ds);
        }
        catch (Exception ex)
        {
            throw ex;
        }
        return ds;
    } 

参考:MSDN如何将 Excel 数据导入 SQL Server