4 replies to this topic

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

[WingedPanther]

The POI library lets you read/write Microsoft file formats. I don't think it will let you run another application and press its button, but I could be wrong.

[ebosysindia]

WingedPanther said:

The POI library lets you read/write Microsoft file formats. I don't think it will let you run another application and press its button, but I could be wrong.

Have you any macro for export data in excel sheet.

[WingedPanther]

Only in ColdFusion, and only for writing TO Excel, not reading from.

You should be able to use JDBC to read the Access data and POI to write it.

[ebosysindia]

O.K. Thanks budy