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

["Jake M" <jakeroc@xxxxxxxxx>]

Michael,

Right now, I have a very similar approach in place. I am using the jxl api
to read from the spreadsheet and push the data onto the iSeries. I have a
DSN set up on my NT box where the jsp's and servlets are running. I use the
JDBC/ODBC bridge to read the data from the spreadsheet and then I am using
the jxl api to write to the iSeries. This approach is taking the users too
long...any modification which would save some time is most welcome..

cheers,

Jake.

On 4/25/06, Michael Ryan <michaelrtr@xxxxxxxxx> wrote:
>
> 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.
> >
> >
> --
> 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.
>
>