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

using Apache POI to save Excel data

 
Nash kumar
Greenhorn
Posts: 20
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am trying to read an excel and write the columns to Database (server 2008). I am using Apache POi and able to read the excel sheet. Could any one help me in reading and writing the columns to database from excel? thank you.

I have 9 columns in excel and want to save these 9 columns to database table that I created.
 
Ulf Dittmer
Rancher
Posts: 42968
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Since you're able to read the file, is this question purely about storing data to a DB? If so, are you familiar with the JDBC API?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic