In Client Access you can set up the data transfer from and to an iSeries server. You can manage your add-ins from there.
Here is a really quick but step by step method to get data from your 400, iSeries or system i into Excel:
AS/400 to Excel
Long story short there are many ways to skin this cat