• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

display access tabel in excel format

 
sunsay00
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 39
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic