Export to excel

[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.

[administrator]

(05-15-2009 02:47 AM)ebosysindia Wrote:  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.

Why run it as a macro? Why not just connect to the db via Java and create your excel file from your db on the fly when the button is pressed?

You should be able to run your macro through the System.execute call, but I'm really not sure that this is your best approach.