SQL, like Excel, has a long-standing history in organizations. It allows for well-defined relationships between and within tables, making it a powerful language for exploring data hosted in a ...

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. I've used it, fairly straightforward.

Connect to the database We tried this using MS-SQL 2000 Server for the database and Excel from MS Office XP. To query the database, start Excel, go to the Tools menu and click on Add-Ins.