Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Exporting Data (Excel to Oracle)

 
Rose Reid
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is there a way to export data from an Excel spreadsheet and dump the data in an Oracle database (table) in Java? How?
-sixpaws
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
you can save re-save the data as a delimited file, then load it into the database or you can use hssf to read the data from the excel spreadsheet and write the data to the database.
Jamie
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
a few more ideas/articles here
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic