How to retrieve the information from database and publish into excel sheet/spread?

[VigneshKarthick]

Hi, i'm new to bytes. can anyone help me to find the solution for retrieving informations from database and publish into excel sheet/spread sheet? i have done the designing part in java swing. i have stored the data into mySQL database. now i want to retrieve the stored one and execute in excel sheet/spreadsheet. Is there any code or API or JAR file is available?

[nathj]

In the past I have seen folks use the standard JDBC method to retrieve the data and then use POI classes to generate an Excel spreadsheet. Take a look into those for your next step.

Cheers
nathj