Re: Utility for import excel file to db2 file

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

+1 on Scott's POI utility (service program). At my previous position we 
used it to read XLSX spreadsheets, then you can do whatever you want 
with the values. Very easy to use.

*Regards*

*Vern Hamberg*

<cid:part1.AWMEMCFH.qwhK4dwo@centurylink.net>

On 2/1/2025 12:14 PM, Leif Guldbrand wrote:
> 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