|
 
| |
MS Excel Help
- Please note that
MS Excel & Query are not IBS
software products. We provide only limited support for
these products.
-
Custom queries, query/400 training, excel training or installation are
billed at our current hourly rates (billed on a 1/2 hour basis).
How to pull data into Excel 2002 or higher
Excel Import Software Requirements
- Excel 2002 or higher
- IBM Client Access user or administration rights
MU 17, 4 Client Access User Enrollment or
MU 19, 16 Client Access Administrator Enrollment
- IBM Client Access software
version 4 release 5 or higher (V4R5)
- This software may work on excel 2000 or below, Lotus
1-2-3 and/or Quattro Pro but IBS will not support any other software package
or MS version prior to Excel 2002.
Video Presentation of How to Import into Excel
How to pull data into Excel 2002 or higher
- Open MS Excel
- Start a blank worksheet
- Click on Data
- Click on Transfer Data from
iSeries
- Click on Create
new
- Click on OK
- Type in your main server ip
address
- Click on
Next
- Type in ibs400f
- Click on Browse
- Click on the file you
want to pull into excel
- Click on
Select
- the file should appear under selected files and members
- for example: IBS400F/GLD
- Click on OK
- Click on
Next
- Click on
Next
again
- If you want to save this data import file request for present & future
use type in a file name
- This option permits you to pull the data fresh every time the
worksheet is opened
- Click on finish
- All data fields should populate with the requested information
|
