参考一下这个吧!
 /// <summary>   
        /// 将Excel保存到DataSet   
        /// </summary>   
        /// <param name="file">Excel文件</param>   
        /// <returns></returns>   
        private static DataSet ImportExcel(string file)
        {
            DataSet dsExcel = new DataSet();
            FileInfo fileinto = new FileInfo(file);
            if (!fileinto.Exists)
                return null;
            string strConn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + file +
                ";Extended Properties='Excel 8.0;HDR=NO;IMEX=1'";            OleDbConnection conn = new OleDbConnection(strConn);            try
            {
                conn.Open();
                string strSql = "select * from [Cy_BigType$]";
                OleDbDataAdapter da = new OleDbDataAdapter(strSql, conn);
                da.Fill(dsExcel);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
            finally
            {
                conn.Close();
            }
            return dsExcel;
        }