Re: MS Excel ====>> iSeries.

["Michael Ryan" <michaelrtr@xxxxxxxxx>]

If you want to take Excel data to the iSeries, use JDBC/ODBC. I think that's
kinda terrifying, but it's doable. I might take the approach of using JExcel
to get the data from the spreadsheet, then using some mechanism (depending
on data size and frequency) to get the data to the iSeries. FTP, JDBC, data
queues...got some options there.

On 4/25/06, Jake M <jakeroc@xxxxxxxxx> wrote:
>
> Hey Ralf,
> With the CA approach, I have to depend on the end user to make sure that
> the
> data they are trying to upload is compliant with the data types of the
> fields in the physical file I am trying to upload to, right? or is there
> an
> easy way to make the end users adhere to proper formatting of the data? I
> appreciate your input.
>
> cheers,
>
> Jake.
>
> On 4/25/06, ralf.petter@xxxxxxxxxxx <ralf.petter@xxxxxxxxxxx> wrote:
> >
> > Hi Jake!
> >
> > Why not use the Client Access. Client Access Data Transfer Utility can
> > handle the transfer from xls to an iseries physical file yery well.
> Maybe
> > it is better to use the wheel which already is invented.
> >
> > Greetings
> >
> > Ralf M Petter
> >
> >
> >
> >
> >
> --
> This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
> mailing list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
>
>