Is there a java class library out there that helps load data in excel file to a DB table?
3 posts in topic
Flat View  Flat View
Older Post First |   Reply to Topic
TOPIC ACTIONS:
 

Posted By:   neal_ravindran
Posted On:   Tuesday, May 25, 2004 07:25 AM

Is there a java class library out there that helps load data in excel file to a DB table?

Report | Quote This | Send private message | Reply | Print

Re: Is there a java class library out there that helps load data in excel file to a DB table?

Posted By:   folke_polzer  
Posted On:   Wednesday, June 9, 2004 11:28 PM

The answers i have seen sofar will cost you a lot of time. You can do this in a zip with excel jdbc driver from nilostep.
Folke
Report | Quote This | Send private message | Reply | Print

Re: Is there a java class library out there that helps load data in excel file to a DB table?

Posted By:   David_Thornton  
Posted On:   Tuesday, May 25, 2004 04:11 PM

The Jakarta POI enables data in Excel spreadsheet files to be read (and written) from Java. It is then just a matter of using the PreparedStatement.setXXXXXX methods to insert or update rows in the DB table using the data read from the Excel file.
Report | Quote This | Send private message | Reply | Print

Re: Is there a java class library out there that helps load data in excel file to a DB table?

Posted By:   joe_user  
Posted On:   Tuesday, May 25, 2004 09:04 AM

Depending on your needs you may want to look at classes like CallableStatement and Statement and methods to insert BLOBs into a table. All the classes you will need are in the sql package.


A google query like this http://www.google.dk/search?q=insert+blob+oracle+jdbc&ie=UTF-8&hl=da&btnG=Google-s%C3%B8gning&meta=


will also turn up lots of examples.

Report | Quote This | Send private message | Reply | Print
About | Sitemap | Contact