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
posted
0
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.
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to
run our stuff on 16 servers instead of 3.