RE: Best Way to get Excel data to AS/400 -- MIDRANGE-L

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
Painless is a subjective word...  For me it means, a way to get a job done
with the least amount of support calls later :-)  But one suggestion would
be to use java, and one of the EXCEL classes out their (accutate [$$$], or
POI [free])  these classes will allow you to read/write native xls files,
and then you can read the column definitions (ie: text or numeric) and then
after you have read all the column types, you can create a table via sql on
the as/400 to match these data types, and then you iterate through the
spread sheet and populate the table on the as/400.  This could all be
triggered after the FTP to the as/400, and use the run remote command (top
launch the java program) after your PUT command...

Just another idea...

> -----Original Message-----
> From: Chuck Lewis [SMTP:clewis@iquest.net]
> Sent: Wednesday, July 24, 2002 1:30 PM
> To:   Midrange-L
> Subject:      Best Way to get Excel data to AS/400
> Importance:   High
>
> Hi Folks,
>
> We are needing to get data from an RS/6000 to the AS/400. These folks can
> download the files we need via a report writer into Excel and they are
> emailing them to us.
>
> We can save this information to a CSV file, TXT file, etc.
>
> My question is what is the most "painless" way to get this data to our
> AS/400 ?
>
> We are running the Synapse TCP/IP emulation product and it has
> Upload/Download GUI programs aka CA. I've done this before but it can be a
> hassle with numbers, etc.
>
> And then there is also the FTP option which I would think would be a good
> option but I have never done much more than uploads of text information
> with
> that...
>
> So what's the consensus on best way to do this ? We are on V4R5.
>
> Thanks !
>
> Chuck
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
This e-mail message, including any attachments, is for the sole use of the
intended recipient(s) and may contain confidential or privileged
information.  Any unauthorized review; use, disclosure or distribution is
prohibited.  If you are not the intended recipient, please contact the
sender by reply e-mail and destroy the message.