permaculture playing cards
The moose likes JDBC and Relational Databases 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 OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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.
I agree. Here's the link:
subject: JDBC
It's not a secret anymore!