Export to excel

Expand Post »

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.

Similar Threads

How to php export to excel in PHP
Import/Export Excel in VB.NET
import from & export to excel in C#
Need help on export asp.net table to excel in ASP.NET
export excel sheet as a csv in Perl

ebosysindia

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

4 posts
since May 2009

Permalink

May 11th, 2009

Re: Export to excel

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.

stephen84s

Featured Poster

Reputation Points: 653

Solved Threads: 151

Nearly a Posting Virtuoso

Offline

1,316 posts
since Jul 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Java Forum Timeline: OBHT add and remove

Next Thread in Java Forum Timeline: Transparent JButton Artifact Help

DaniWeb Message

Cancel Changes

User Name
Password