RE: Transfer Exell to AS400

[Sanjay Sharma <sanjay_mit@xxxxxxxxx>]

Using MS ODBC and also using clinet acces one can
transfer the Exell spread sheet to DB2 table

never tried with XML

--- Jim Mason <jmason900@yahoo.com> wrote:
> Hi.
>
> MS ODBC using JdbcOdbc driver and AS400JDBCDriver to
> iSeries DB2.  Spreadsheets are xls ...
>
> Jim
>
> --- Chanh_Le@countrywide.com wrote:
> > This is a multipart message in MIME format.
> > --
> > [ Picked text/plain from multipart/alternative ]
> > It would be very helpful if I could have sample of
> > using POI.
> >
> >
> > Using standard JDBC, does it mean using JDBC from
> > Microsoft?  It is Win2k
> > JDBC; I have not try it with XLS file.
> >
> >
> > Thanks,
> > CL
> >
> >
> >
> >
> >
> >
> > "Ducret, Gilles (CH)"
> <Gilles.DUCRET@lloydsbank.ch>
> > Sent by: java400-l-admin@midrange.com
> > 03/05/2002 07:27 AM
> > Please respond to java400-l
> >
> >
> >         To:     "'java400-l@midrange.com'"
> > <java400-l@midrange.com>
> >         cc:
> >         Subject:        RE: Transfer Exell to
> AS400
> >
> >
> > 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 ]
> > Is it possible to get a sample to transform Excell
> > to XML using
> > POI. I can't find it on their web site?
> >
> > -----Original Message-----
> > From: Jim Mason [mailto:jmason900@yahoo.com]
> > Sent: mardi, 5. mars 2002 16:12
> > To: java400-l@midrange.com
> > Subject: Re: Transfer Exell to AS400
> >
> >
> > Hi.
> >
> > I've been able to read and write Excel
> spreadsheets
> > to
> > and from DB2 data on different platforms without a
> > problem just using standard JDBC drivers...
> >
> > Jim Mason
> >
> > --- David Morris <David.Morris@plumcreek.com>
> wrote:
> > > CL,
> > >
> > > I am not sure why you need the intermediary step
> > to
> > > XML, but
> > > it would seem that the challenge is getting the
> > .XLS
> > > file to XML.
> > > I do not know if this will help, but the POI
> > project
> > > does offer
> > > Java support for Excel files. POI is also now
> part
> > > of the
> > > Apache Jakarta project and is likely to pick up
> > > quite a bit
> > > of interest.
> > >
> > > If you are interested go to
> > > http://jakarta.apache.org/poi/ and
> > > check it out. I know that POI will run on the
> > > iSeries and others
> > > are using it to create XLS files. I don't know
> of
> > > anyone using
> > > it to read from .XLS files, but it is definitely
> a
> > > goal of the
> > > project.
> > >
> > > David Morris
> > >
> > > >>> Chanh_Le@countrywide.com 03/01/02 07:01PM
> >>>
> > > This is a multipart message in MIME format.
> > > --
> > > [ Picked text/plain from multipart/alternative ]
> > > Could you let me know where I can find an
> example
> > > how to load an MS
> > > Exell
> > > spreadsheet to XML then post to AS400 file.
> > >
> > >
> > > Thanks.
> > > CL
> > > _______________________________________________
> > > This is the Java Programming on and around the
> > > iSeries / AS400 (JAVA400-L) mailing list
> > > To post a message email: JAVA400-L@midrange.com
> > > To subscribe, unsubscribe, or change list
> options,
> > > visit:
> > >
> >
> http://lists.midrange.com/cgi-bin/listinfo/java400-l
> > > or email: JAVA400-L-request@midrange.com
> > > Before posting, please take a moment to review
> the
> > > archives
> > > at http://archive.midrange.com/java400-l.
> > >
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Try FREE Yahoo! Mail - the world's greatest free
> > email!
> > http://mail.yahoo.com/
> > _______________________________________________
> > This is the Java Programming on and around the
> > iSeries / AS400 (JAVA400-L)
> > mailing list
> > To post a message email: JAVA400-L@midrange.com
> > To subscribe, unsubscribe, or change list options,
> > visit:
> >
> http://lists.midrange.com/cgi-bin/listinfo/java400-l
> > or email: JAVA400-L-request@midrange.com
> > Before posting, please take a moment to review the
> > archives
> > at http://archive.midrange.com/java400-l.
> >
> >
> >
>
**********************************************************************
> > This E-mail and any files transmitted with it are
> > confidential
> > and intended for the exclusive use of the
> > addressee(s) only.
> >  You should not disclose its contents to any other
> > person.
> > If you are not the intended recipient please
> notify
> > the sender
> > immediately.
> >
>
**********************************************************************
> > _______________________________________________
> > This is the Java Programming on and around the
> > iSeries / AS400 (JAVA400-L)
> > mailing list
> > To post a message email: JAVA400-L@midrange.com
> > To subscribe, unsubscribe, or change list options,
> > visit:
> >
> http://lists.midrange.com/cgi-bin/listinfo/java400-l
> > or email: JAVA400-L-request@midrange.com
> > 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@midrange.com
> > To subscribe, unsubscribe, or change list options,
> > visit:
> >
> http://lists.midrange.com/cgi-bin/listinfo/java400-l
> > or email: JAVA400-L-request@midrange.com
> > Before posting, please take a moment to review the
> > archives
> > at http://archive.midrange.com/java400-l.
> >
>
=== message truncated ===


__________________________________________________
Do You Yahoo!?
Try FREE Yahoo! Mail - the world's greatest free email!
http://mail.yahoo.com/