RE: Transfer Exell to AS400

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


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