I have data in ms-access database.I want to export it to Excel on click of a button which is in front end developed in core java.
I am working on frames NOT applet.


I developed a macro in access to export data to excel.
But i dont know how to run this macro on click of a button in core java application.
Is it possible to run ms-access macro on click of a button in core java application?


If not possible kindly suggest some other way.


Kindly do me a favour in this regard.


Thanks in advance.

Yes you can do it in Java but, I think you're going the wrong way about it.
If you use SWT, you can access both MS Access and Excel with your java program. You will need to ship the dlls or so's depending on the user's OS.

However, I think you'd be much better off using JDBC to get the data from Access, and using POI to create your spreadsheet. Just skip the whole macro bit entirely.