This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes JDBC and the fly likes JDBC Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC" Watch "JDBC" New topic


pavankumar iragavarapu

Joined: Nov 01, 2006
Posts: 3
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

Joined: Mar 06, 2001
Posts: 13459

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.
jQuery in Action, 2nd edition
subject: JDBC