Win a copy of Learn Spring Security (video course) this week in the Spring forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC

 
pavankumar iragavarapu
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
please provide me with the information like

how to insert the values from excel sheet into a table.
that is if we provide an excel sheet as an input, a table should automatically created based on the number of coloums in the excel sheet.
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
There are tools such as xlsql that allow you to treat Excel docs as a JDBC DataSource, from there you just need to transfer from one to the other. I'm not aware of an automatic way to do it though.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic