It's not a secret anymore!
The moose likes JDBC and Relational Databases and the fly likes inserting values in the Excel sheet Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "inserting values in the Excel sheet" Watch "inserting values in the Excel sheet" New topic
Author

inserting values in the Excel sheet

pappitha swaminathan
Greenhorn

Joined: Aug 16, 2011
Posts: 9
Hi all,
could you please help me in inserting values into the excel sheet using jdbc???
Ulf Dittmer
Rancher

Joined: Mar 22, 2005
Posts: 42958
    
  73
Use the right tool for the job - JDBC is an API to access databases. A library like Apache POI, on the other hand, is perfect for handling XLS and XLSX files.
vineet dhar
Greenhorn

Joined: Aug 17, 2011
Posts: 23
pappitha swaminathan wrote:Hi all,
could you please help me in inserting values into the excel sheet using jdbc???




You can use the Type 1 JDBC Driver to enter the values into the Excel Sheet....i.e. Microsoft JDBC-ODBC driver..but check the version of jdk,,it might be deprecated..
Prateek Jauhari
Greenhorn

Joined: Mar 07, 2011
Posts: 26

Why you wanna use JDBC for excel insertion. ?
POI interface is good tool to handle excel operations in JAVA
pappitha swaminathan
Greenhorn

Joined: Aug 16, 2011
Posts: 9
vineet dhar wrote:
pappitha swaminathan wrote:Hi all,
could you please help me in inserting values into the excel sheet using jdbc???




You can use the Type 1 JDBC Driver to enter the values into the Excel Sheet....i.e. Microsoft JDBC-ODBC driver..but check the version of jdk,,it might be deprecated..


yeah i used but its not working.. throwing an exception..
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: inserting values in the Excel sheet
 
It's not a secret anymore!