Link to home
Start Free TrialLog in
Avatar of heze54
heze54Flag for Spain

asked on

Iseries 515 v5r4 create excel files

Hi,

Right now, when I want to extrac some info from my iseries 515 v5r4 I can create pdf files, save them or send them to a specific email user.

I'd like to co the same but create excel files

Is this possible?

Regards
Avatar of Member_2_2484401
Member_2_2484401
Flag of United States of America image

I frequently import iSeries data into MS Access via ODBC. I can then easily export it into MS Excel.

Alternately, you can use the CpyToImpF command to export a database file into a comma-delimited text file (which can easily be loaded into Excel).

HTH,
DaveSlash
Avatar of heze54

ASKER

Hi,

the information is already at my iseries system.


Cvs files, can be transformed on the fly to a xls file?

The command you told me, is a system command?

Regards
ASKER CERTIFIED SOLUTION
Avatar of Gary Patterson, CISSP
Gary Patterson, CISSP
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
You can use the standard filetransfer that is available in you Client Access,
or, write a HTML tabel to a file and give it the extention .XLS  Excel accept that as excel data