I seen it on many ASP driven sites. The developer will provide an option for the user to exort the DB query results into Word Doc or Excel by clicking on a link on the page. I would appreciate it if you send me in the right direction.
Export a file using something like comma delimited format or an xml format and you can open it in Excel. All you have to do is dump the output into a string properly and build the file.
Even simpler. Write the data using a normal table structure. Use Response.ContentType = "application/vnd.ms-excel" to tell the browser it's Excel. Use Response.AddHeader "Content-Disposition", "attachment; filename=filename.xls" to force a download of the file instead of viewing in the browser.
You could perhaps use IMEX to export to CSV on the server then just download it ie the following SQL (should - not tested) dump the member names and email addresses into a text file called Export.CSV on the server
SELECT M_NAME, M_EMAIL INTO [TEXT;HDR=YES;Database=" & Server.MapPath("/") & ";IMEX=4;].Export.CSV FROM FORUM_MEMBERS
Topic Locked
Posted - 07 March 2005 : 20:22:26
