Export to excel

ebosysindia · #1 (**permalink**) 05-25-2009, 07:51 AM

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 · #2 (**permalink**) 06-30-2009, 10:36 AM

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 · #3 (**permalink**) 07-16-2009, 05:01 PM

Quote:

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 ?

candiid · #4 (**permalink**) 06-03-2010, 10:27 AM

Quote:

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

I think this should solve the trouble and will not cause the trouble forward .

jackson24771 · #5 (**permalink**) 12-03-2010, 10:44 AM

Microsoft Excel starts, and the entire data set or any data mapped entirely within the shape you drew is exported and presented in an Excel workbook (see the notes below for more information). The workbook includes a header sheet with the dimensions of the area you selected, the name of each data set that was included, and the total number of records exported from each set.

MATHEW · #6 (**permalink**) 06-23-2011, 11:20 AM

First open Microsoft Excel , and any data mapped entirely within the shape you drew is exported and presented in an Excel workbook .
The workbook includes a header sheet with the dimensions of the area you selected, the name of each data set that was included, and the total number of records exported from each set.

vikramrandhawa · #7 (**permalink**) 09-16-2011, 07:16 AM

Hey its Very easy to export excel sheet...
In asp.net when you fetch the data from database with databound controls ..
Then Just Code Online export.gridview1.name of the File