Using SQL statements in Excel enables you to connect to an external data source, parse field or table contents and import data – all without having to input the data manually.

I am using JSP, Tomcat, and SQL Server 2008 R2. ... If you aren't using Spring, then you can either export as CSV (excel reads those OK), or use Apache POI to create an excel file.