Re: Utility for import excel file to db2 file

In case anyone is interested, I started a post about using IBMi ACS automation to upload/download files to the IFS using the Data Transfer functionality.

Found an older Craig Pelkie Ocean presentation on this from wait for it...wait for it..... That's right: 2012.

ACS already luck 13yrs old. Where does the time go.

Documenting it for posterity in case someone wants to use this functionality.

https://github.com/richardschoen/howtostuff/edit/master/acsautomation

Regards,
Richard Schoen
Web: http://www.richardschoen.net
Email: richard@xxxxxxxxxxxxxxxxx


----------------------------------------------------------------------

message: 1
date: Sat, 1 Feb 2025 19:14:28 +0100
from: "Leif Guldbrand" <Guldbrand@xxxxxxxxx>
subject: Re: Utility for import excel file to db2 file

I did this many years ago, both from an iSeries database to a Win PC within Excel and from Win PC Excel to a database in the iSeries. So, it's doable.

At the end of workday, the person in charge startet a job from his PC and updated his new data from Excel to the iSeries, where the DB got updated.

From the iSeries (with new data too), a job started at midnight and after end, both the Excel DB and iSeries DB were equal.

As I remember, I used Scott Klements POI utility: https://tinyurl.com/24t4995y

Regards, Leif

---- Original Message -----
From: gio.cot via RPG400-L <rpg400-l@xxxxxxxxxxxxxxxxxx>
Reply-To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
To: 'RPG programming on IBM i' <rpg400-l@xxxxxxxxxxxxxxxxxx>
Cc: gio.cot <gio.cot@xxxxxxxxxxx>
Sent: 01-02-2025 16:11:52
Subject: Utility for import excel file to db2 file ________________________________________________________________________________

Hi all

I'm looking for an free utility (if exist), to invoke from RPG
program, for import data from excel to Ibm i file; could you share
which command/programs do you use ?

Thanks in advance

Gio