File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Java in General and the fly likes Transfer Excel Sheet information to database Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Java » Java in General
Reply Bookmark "Transfer Excel Sheet information to database" Watch "Transfer Excel Sheet information to database" New topic
Author

Transfer Excel Sheet information to database

jyoti Dadsena
Greenhorn

Joined: Feb 04, 2008
Posts: 10
posted private message
0
Quote
Can it possible to transfer my Excel sheet Data into database through sql query?which query i apply for this?
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 35243
    
    7
posted
0
Quote
Not directly. You'll need to read the contents of the XLS file (using a library like Apache POI or jExcelApi), and then you can insert data into the DB using JDBC.

Android apps – ImageJ plugins – Java web charts
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Transfer Excel Sheet information to database
 
Similar Threads
write and read Excel File
Reading XLS file
WA #1.....word association
create a excel sheet fom java and jsp
Code for transfering data from JSP to Excel Sheet