Reports

[hsp]

Dear All,

I will take a query in AS400(WRKQRY), & after that I need to update the count in the excel sheet.

It is a repetative task, please let me know how to automate it in excel.

Thanks
Hsp

[BenThurley]

Re: Reports

I had a module at uni where we did something like this. The title of the piece of work was "Using Excel as an OLAP tool".

We had an Oracle database already set-up for us and the task was to create an OLAP cube using Excel. I think there was a plugin for Excel that included a database driver. You then create a cube using a wizard in Excel plus a bit of VBA scripting. Once it's setup you can refresh the report from the database at the click of a button in Excel.

I don't know if you can do this with DB2 on the AS400 but it might be worth looking at.