Home > IT Answers > AS/400 > Convert as400 file to Excel and Pdf
As400programm
10 pts.
 Convert as400 file to Excel and Pdf
AS/400 to PDF, DB2/400, Exporting AS/400 to Excel, PDF, Physical File
I would like to transfer a PF data into Excel , my add ins not working. Can u provide me any other ways to do that.

Software/Hardware used:
AS400
ASKED: January 12, 2010  6:48 AM
UPDATED: July 28, 2011  8:35 AM
RELATED QUESTIONS
Answer Wiki:
Use the CPYFRMIMPF command to create a CSV file on the IFS. The open it with excel. You can also look into using the Apache POI APIs to create the sheet in excel directly from your program. Check the archives for examples of how to do both of these. ********** You can also use ODBC to download directly from your AS400 to a spreadsheet... here is a step by step tutorial for <a href="http://www.as400tutorials.com/as400-to-excel/">downloading as400 to excel</a> If you have Client Access installed on your system then you should have the ODBC driver to do this. There are also lots of third party software packages that allow you to query into spreadsheets.
Last Wiki Answer Submitted:  January 15, 2010  4:58 pm  by  Teandy   5,830 pts.
All Answer Wiki Contributors:  Teandy   5,830 pts. , Littlepd   1,130 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

You say
‘ my Add ins not working’

If you have the tools already there, why not fix whatever is stopping it from working?

Yorkshireman
 5,505 pts.