Excel-Access-DB2 Data Exchange

As you may be aware, with older versions of Excel you were limited to the number of rows which could be used.  Mid-level managers at large publicly traded company were comfortable performing various reporting and forecasting functions using Excel.  Unfortunately, the amount of data delivered during end of the month reporting frequently exceeded the capabilities of Excel.  Complicating the issue was the fact that data had to be gathered from both local Access databases and corporate mainframes.

I developed a series of customized Excel and Access macros which allowed them to break down the large data sets based on a number of criteria.  This facilitated their ability to use an interface they were comfortable with (Excel) while still allowing them to deal with and manage large volumes of information.