Re: Transfer Exell to AS400

[Patrick.F.O'Dowd@xxxxxxx]

I have used jdbc to load excel spreadsheet to as400 files:
               Connection excelConnection = null;
               Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
               excelConnection = DriverManager.getConnection("jdbc:odbc:" + 
odbcName, "", "");


               Statement excelSelect = null;
               excelSelect = excelConnection.createStatement();
               String excelQuery = "select * from [Contacts$];"; //Excel sheet 
name
               ResultSet excelData = excelSelect.executeQuery(excelQuery);

               while (excelData.next()) {
                           String node = excelData.getString("Node");
                           String contactName = excelData.getString("Contact 
Name");

                    etc..

To convert the excel data to XML, you could use JDOM.





Chanh_Le@countrywide.com@midrange.com on 02/03/2002 02:01:38

Please respond to java400-l@midrange.com

Sent by:  java400-l-admin@midrange.com


To:   java400-l@midrange.com
cc:
Subject:  Transfer Exell to AS400


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.