× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



GREAT idea from the sounds of it Tim - If I had a CLUE as to how to do the
Java part :-) Even have a Java CD but have not gotten around to finding the
time to seriously devote to learning it... "One man shop" and "you know
whats to the walls" lately. Thanks !

Chuck

-----Original Message-----
From: midrange-l-admin@midrange.com
[mailto:midrange-l-admin@midrange.com]On Behalf Of Hatzenbeler, Tim
Sent: Thursday, July 25, 2002 10:29 AM
To: 'midrange-l@midrange.com'
Subject: RE: Best Way to get Excel data to AS/400


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.
_______________________________________________
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.





As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.