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.

[Symbyo SEM]

I'm guessing you'll need to to use excel objects to do this. Here's a starting point:

support.microsoft.com/kb/198571

[stevepeterson]

Originally Posted by 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.

I can't understand you question properly. Can you please explain in brief ?