How to Use SQL Statements in MS Excel. With most Excel spreadsheets, ... a SQL Server database or even a large text file, you can also retrieve data from it using Excel.

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.

Here, you might have customer information in an Excel file, order details in a SQL Server database, and marketing campaign ...