Hi,

I have a table on a web page that i wish the user to be able to save to his computer.

I don't want all the navigation or footers that are saved if you use save page as.

JUST THE TABLE

How do i do this please.

Cheers

Steve

How about a link that links to a page the only outputs the table?

Did a Google search...
http://www.codeproject.com/aspnet/Ex...ort_button.asp

Here is one from Expert Exchange (please know that I did not write this and take no credit, visit the link below for the full thread)...
http://www.experts-exchange.com/Web/..._21288109.html

Here's how i usually create CSV file and some simple sample codes.


<%
'sOutput stores the final output
'sData stores each line output

'==== write the title (name of the column) ===
sData = Chr(34) & "First Name" & Chr(34) & ","
sData = sData & Chr(34) & "Last Name" & Chr(34)

sOutPut = sOutPut & sData & vbCrLf

'===== now output 1 line of data =======
sData = Chr(34) & "John" & Chr(34) & ","
sData = sData & Chr(34) & "Doe" & Chr(34)

sOutPut = sOutPut & sData & vbCrLf

FileName="myTestFile.csv" 'default file name

Response.Clear
Response.ContentType = "text/csv"
Response.AddHeader "Content-Disposition", "filename=" & FileName & ";"
Response.Write(sOutPut)
%>

in your actual code, you would replace the "output 1 line of data" part with a recordset loop to output all your records (which means you would have to run the same query).
In your main page where you display the records in html, you can add a submit button for export to CSV. When you submit the form to create CSV, it should open a dialogue for "save as", and then you can save the csv file in your local machine.

have not tried FtB's way before. I might try it the next time i work on csv export

kingsfan

Sorry for posting again (slow day)... I found a DW extension that will download to CSV. I haven't used it, but this site is usually reliable for this sort of thing.

http://www.basic-ultradev.com/articl...ion/index.html