View original (French)

Importing data from an IBM AS400 server to EXCEL

Marcelinos Posted messages 353 Status Membre -  
razson Posted messages 2 Status Membre -
Hello, I made a request on an IBM AS400 server (in the "Data Analysis" option)! When I execute it (with F5 to display the Report), I get exactly what I want! I saved the analysis under the name GB_Clients. Now I want to import the data from my query into Microsoft Excel for further processing, but I don't know how to do it! This is honestly what is bothering me because I am a beginner on the AS400 server!

I need your help.....

Thank you very much in advance....

Happy New Year 2015 to the entire CCM community!

Configuration: Windows 7 / Chrome 39.0.2171.95

--

2 réponses

Réponse 1 / 2
Célien Posted messages 5702 Registration date   Status Membre Last intervention   1 995
 
Hi,

We've already talked about it here if it can help you: AS/400 and Excel.
0
Réponse 2 / 2
razson Posted messages 2 Status Membre
 
With Access Iséries, you can go through the extraction via the sub-menu Action->Receive a file from the host system. You then specify the types of files you want and the processing is done. However, you will need to create the file in your query and place it in a library. Then, through the extraction module, you specify the access path and the extraction format (in your case, Excel).

--
Best regards
0