Meaningless Drivel is fun!*
The moose likes JDBC and the fly likes save the data import as a Excel File Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "save the data import as a Excel File" Watch "save the data import as a Excel File" New topic
Author

save the data import as a Excel File

Huang Chung-Yu
Greenhorn

Joined: Aug 29, 2004
Posts: 2
I use jBuilderX and MS-SQL Server 2000..
now..when I read data from MS-SQL Server..
How can I save the data import as a Excel File..
such as..

String test = "Select id,name from abc";
db.executeQuerySql(test);

id name
01 john
02 May

now..I just want to save those data as a test.xls
how can I use jBuilderX to do??
Help me!!

[Bear edit: changed the topic title to something more meaningful than "Help me!!!"]
[ September 20, 2004: Message edited by: Bear Bibeault ]
Alan Ford
Ranch Hand

Joined: Oct 26, 2003
Posts: 107
Googled it? Try to Google POI?


TNT<br />MCP, SCJP 1.4,
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: save the data import as a Excel File
 
Similar Threads
how to store values(data) from excel into mysql
Database output results to Excel
Jdbc with MS-excel
MS EXCEL Connect
how to extract data to an xl sheet