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.
csimonds
Are you using IBM iSeries Access (Client Access, as some know it)?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
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
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
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
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
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"
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"