RE: xfer state of the art - unattended

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 ]
Have the excel file saved in your ifs, and then use the POI jar found on the
jakarta project to read the .xls nativly on your as/400, to fill the fields
in your db2 files either with a jdbc, or record level access writes...

this would require java though...

just an idea... tim



> -----Original Message-----
> From: Jerome Draper [SMTP:jdraper@trilosoft.com]
> Sent: Friday, December 06, 2002 1:56 PM
> To:   Midrange List
> Subject:      xfer state of the art - unattended
>
> Any ideas as to an unattended canned approach to an Excel to AS400 file
> transfer?
>
> I'm thinking that you have extract the data from Excel in a common
> denominator file format like comma delimited.  Is there a tool for this?
> I
> don't want the operator to have to load Excel and do it themselves.
>
> Beyond that I know they can use ETU, strpco, strpcpcmd, or runrmtcmd to do
> the file transfer.
>
> This has to be no operator intervention required.
>
> Jerry
>
>
> Jerome Draper, Trilobyte Software Systems, since 1976
> Network and Connectivity Specialist -- Mac's, LAN's, PC's, and iSeries
> Representing Synapse, Nlynx, Perle, CLI, Intermate and Others .....
> (415) 457-3431 - (415) 258-1658fax - http://www.trilosoft.com
>
>
>
>
> _______________________________________________
> 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.