Java

Export to excel

Please support our Java advertiser: Programming Forums - DaniWeb Sister Site

•

Join Date: May 2009

Posts: 4

Reputation: ebosysindia is an unknown quantity at this point

Solved Threads: 0

ebosysindia ebosysindia is offline

Offline

Newbie Poster

Export to excel

May 11th, 2009

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.

software application development | website development | java game development

•

Join Date: Jul 2007

Posts: 1,175

Reputation: stephen84s is a glorious beacon of light

Solved Threads: 125

stephen84s stephen84s is offline

Offline

Veteran Poster

Re: Export to excel

May 11th, 2009

I do not know how to execute a macro, but what you could do is Query your MS-Access database and write the values from the recordset into a file CSV format (which can be opened in Excel) or alternatively you could use Apache POI to write it out in the proprietary Excel format.

"Any fool can write code that a computer can understand. Good programmers write code that humans can understand."

"How to ask questions the smart way ?"