Forum Moderators: open

Message Too Old, No Replies

Export to excel

         

ebosys1

8:26 am on May 8, 2009 (gmt 0)

10+ Year Member



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.

[edited by: coopster at 2:23 pm (utc) on May 8, 2009]
[edit reason] no signatures please TOS [webmasterworld.com] [/edit]

tangor

10:20 am on May 8, 2009 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month



Your export mode? CSV? Should work day in day out. Nifty one click solutions require skull sweat and testing, else just export it via excel's "save as" then upload to server and script which can read csv. Data is data. Java has nothing to do with that.