GeeCON Prague 2014*
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


JavaRanch » Java Forums » Java » Java in General
Bookmark "display access tabel in excel format" Watch "display access tabel in excel format" New topic
Author

display access tabel in excel format

sunsay00
Greenhorn

Joined: Aug 29, 2001
Posts: 1
Hi,
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?
Thanks
--John
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:
1,'test',5
6,'Blah',8
etc...
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.
 
GeeCON Prague 2014
 
subject: display access tabel in excel format