aspose file tools*
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
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.
I agree. Here's the link:
subject: JDBC