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
Author

JDBC

pavankumar iragavarapu
Greenhorn

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
Rancher

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.
 
 
subject: JDBC
 
Similar Threads
scrolling a table
How To Comapre To Excelsheet
Excel Reading
WA #1.....word association
Editing an Excel Sheet using javascript