AS/400-to-Excel downloading

[David Morrison - Corporate]

Hello, all

We currently download several different subfiles (created by both QTP and
QUIZ programs) from our AS/400, on a regular basis, for users who want to be
able to "slice and dice" data in MS-Excel.  The frequency and variety of
these downloads is trending upwords.  We use IBM's Client Access to perform
the downloads (we get the same result if we use ODBC to import data into
Excel).

We want to be able to include column headings as the first row of the Excel
spreadsheets (currently, we have to hand-enter them, in some cases).   The
default headings for such columns are "F0000", "F0002", "F0004", etc.  If we
use the DDS FIELD clause on the ELEMENT statements in the data dictionary,
and reload the associated data files, we can make our own DDS field names
that successfully download to Excel.  However, when we create subfiles in
QTP or QUIZ FROM these dictionary files, the field names are lost, and we
get just the default heading names, as above.

Outside of specifying all the possible subfiles within our data dictionary,
does anyone out there have an idea for how we can accomplish what we want to
do?

Note that we're on an older CISC (V3R2) model AS/400.

Thanks.

David Morrison