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 ?

[candiid]

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]

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]

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]

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

[vimaljaya]

1) Styling : If you used "HeaderStyle", "RowStyle", "AlternateRowStyle" in your GridView, you can simply enable styling by setting the "ApplyStyleInExcel' property to "True". Note: CSS styling is not supported at this point future candidate


2) TimeStamp: If you set the "IncludeTimeStamp" to true, the filename is appended with a "time Stamp". These are very useful for time sensitive reports.

3) PageSize: If you are using Pagination in your GridView, you can choose to export the "Current" page, the "Entire Grid" all pages or set a specific number of records to export. Use "All" for all pages, "Current" for the current page and 20 for first 20 records.


4) Sorting: The Export supports sorting. In otherwords, if you sort your gridview and then export, the excel spreadsheet will also be sorted.

5) GridViewID: If you have more than one gridview in a page, you can specify which gridview you'd like to export by setting this property. You do not have to set any value if you just have one grid view.

[Tom_141]

try excel plugins for database provided over internet that works as a bridge between the two

[queHalcoe]

MS Access has a number of Wizard functions that create the SQL statements necessary to import MS Excel workbooks or spreadsheets into Access.