save SQl query result into excel file

Expand Post »

I want to store the results generated out of SQL query into excel file ...
how do I go about doing it?
help

Similar Threads

Manipulate Excel file using C++?? in C++
Get data out of excel file stored as an image in MS SQL
putting result of a sql query in a file in shell scripting in Shell Scripting
record results in excel file from vb in VB.NET
Javascript array from sql query in JSP

Dhanesh.M

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

5 posts
since Apr 2007

Permalink

May 18th, 2007

Re: save SQl query result into excel file

Read up on JDBC, first (the Sun tutorials are enough).

Then download, read the documentation for, and experiment with, either POI or JExcel.

Then, combine the lessons learned from the two above points.

masijade

Moderator

Reputation Points: 1471

Solved Threads: 490

Industrious Poster

Offline

4,043 posts
since Feb 2006

Permalink

May 18th, 2007

Re: save SQl query result into excel file

or write your own code to write out SLK...
Not the nicest code to look at, but you loose dependencies on another few external libraries which may be worth it.

jwenting

Team Colleague

Reputation Points: 1658

Solved Threads: 331

duckman

Offline

7,719 posts
since Nov 2004

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Java Forum Timeline: GUI Input

Next Thread in Java Forum Timeline: Help!! How can this be done?

DaniWeb Message

Cancel Changes

User Name
Password