File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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 RabbitMQ in Depth this week in the Open Source 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