• 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
 
my overalls have superpowers - they repel people who think fashion is important. Tiny ad:
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!