You have a couple of options:

First you could create a CSV file which could be imported into excel.
Another option would be to use the JDBC ODBC bridge in conjunction with the
Excel ODBC driver.

See this article for more info on this. Also, Javaworld is an excellent
source for Java questions.

http://www.javaworld.com/javaworld/j...629-excel.html
http://www.javaworld.com/javaworld/j...24-excel2.html

Good Luck,

Rob

pervez <p_nadeem@yahoo.com> wrote:
>Does ne1 know how or have the source code to be able to query sql tables

and export
>them to an excel spreadsheet. Using JSP, JAVA, BEans, Servlets, XML??
>
>please help me!