利用Excel做数据源访问Excel中表的数据

　　　string mystring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Path\\FileName.xls;Extended Properties=Excel 8.0;";
        OleDbConnection conxls = new OleDbConnection(mystring);
        string sql = "SELECT   *   FROM   [Sheet1$]";
        OleDbDataAdapter da = new OleDbDataAdapter(sql, conxls);
        DataSet ds = new DataSet();
        da.Fill(ds);
        return ds;