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 | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Java in General
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
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: 39548
    
  27
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.


Ping & DNS - updated with new look and Ping home screen widget
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Transfer Excel Sheet information to database
 
Similar Threads
create a excel sheet fom java and jsp
Reading XLS file
write and read Excel File
Code for transfering data from JSP to Excel Sheet
WA #1.....word association