How to transfer a list from AS400 to Excel

A user needs to trasnfer a list from AS400 to Excel. I have the query name and the library name, Can anyone tell me how to do it? Do I need to create an ODBC in Windows? Is there any option in Excel that should be activated in order to catch the list? Your Help will be greatly appreciated.
Hunter24Office 365 Support EngineerAsked:
Who is Participating?
 
Bruce CadizQuality SpecialistCommented:
Hunter24,

here is a step by step using ODBC
http://cornellcollege.edu/information_technology/database/AS400Excel.PDF

Bruce
0
 
csimondsCommented:
Are you using IBM iSeries Access (Client Access, as some know it)?
0
 
daveslaterCommented:
Hi
use WRKQRY to start query. take option 2 (change) and enter the query name and library

select the
"Select output type and output form "
and ensure the output to 3=database file.

IMPORTANT MAKE SURE DO DO NOT REPLACE A LIVE DATABASE FILE

then run the query on exit.

If you have client access installed there shoule be an excel plug-in. In excel use
Tools>>Add-Ins
in client access is not there use <Browse> then select folder
C:\program Files\IBM\Client Acess\shared\
and select cwbtfxla.xll
The  simply download it into excel.

Dave
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
jordibartrinaCommented:
Hello,

First mode: You can use CA/400 for send a file directly to xls format, and automatize it with rtopcb.
Second: Export file to IFS with cpytoifs and retrieve it to your pc.
Last: You can use a tool named xprtf (download for free here: http://www.recursos-as400.com/fonts/dbf400.exe) this tools can import/export files from/to as/400 and obtain .txt, .csv and .dbf. The three types of files can be open in MS Excel.

HTH
0
 
tliottaCommented:
Hunter24:

Please clarify if the "query" is expected to run each time before the download to Excel and if running the query should be part of your desired answer. Is the query used _only_ to create this list or is it also used elsewhere? Can you (or another developer) create queries as needed?

Tom
0
 
jordibartrinaCommented:
Hello again,

New suggestion: convert outfile of your query to a comma separated flat file in IFS. Then send it via FTP to a ftp server in your lan. Send a message to the user: "Transfer done. File ready"
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.