aspose file tools
The moose likes JDBC and the fly likes exporting data from spreadsheets to oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "exporting data from spreadsheets to oracle" Watch "exporting data from spreadsheets to oracle" New topic
Author

exporting data from spreadsheets to oracle

sathish pancha
Greenhorn

Joined: Jan 24, 2009
Posts: 1
posted private message
0
Quote
how to export data from spreadsheets to orcle
Bauke Scholtz
Ranch Hand

Joined: Oct 08, 2006
Posts: 2458
posted
0
Quote
Use Apache POI HSSF or Andy Khan JExcelAPI to extract data from Excel sheets into useable Java objects. Finally use the JDBC API to persist data in the database.

Code depot of a Java EE / JSF developer | JSF / Eclipse / Tomcat kickoff tutorial | DAO kickoff tutorial | I ♥ Unicode
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: exporting data from spreadsheets to oracle
 
Similar Threads
Read a .xls,.xlsx file format using XSSF
creating a DSN
adding data to an existing spreadsheet
data from data base to excel in servlet
getting data from excel with poi