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
posted 14 years ago
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.