aspose file tools*
The moose likes Java in General and the fly likes display access tabel in excel format Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Java » Java in General
Bookmark "display access tabel in excel format" Watch "display access tabel in excel format" New topic

display access tabel in excel format


Joined: Aug 29, 2001
Posts: 1
I trying to display the tables from a access database to the browser in excel format so the user can save the data in a excel files. Does anyone have any idea of how to do this?
Thomas Goorden
Ranch Hand

Joined: Aug 15, 2001
Posts: 39
Build comma seperated files (csv-files) from the Access data, separating the different records by new lines, different fields with comma's:
Next, call the system asking it to open the file (servlets do this easily using a MIME type), I'm sure you can figure the rest out yourself.
I agree. Here's the link:
subject: display access tabel in excel format