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

Transfer Excel Sheet information to database

 
jyoti Dadsena
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can it possible to transfer my Excel sheet Data into database through sql query?which query i apply for this?
 
Ulf Dittmer
Rancher
Posts: 42968
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Not directly. You'll need to read the contents of the XLS file (using a library like Apache POI or jExcelApi), and then you can insert data into the DB using JDBC.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic