Valhalla Legends Forums Archive | Java Programming | Export to excel

AuthorMessageTime
ebosysindia
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.
May 11, 2009, 4:58 AM
Camel
Is it a requirement to use the access macro? If not, I'd take a completely different approach; query the database using JDBC (there should be an ODBC bridge connector in there somewhere), and dump the data to excel using XElem or POI.
May 21, 2009, 7:56 PM

Search