[traceMe]

guys iam doing some research on exporting the data from database to access, excell, txt, files and ne other way through which i can export the data. Can you guys help me in this matter......
I have data in my ms-sql 2000 online now if i want to view it on my desk offline then i'll have to put the software in first case and then import it from online database.....but I dont intend to do that.......rather if I put up a link on a page that says export and that exports the data to a excel file.....I dont mind uploading a excel file..........or whatever.....
please help me.................
I had earlier seen a code that reads from excel file i guess in that case its also possible to write it in excel file.........
now I want to

[ksroadrunner13]

I'm doing something similar on the site that I'm working on. I have to generate a monthly report from an access database in excel format. Excel spreadsheets are nothing more than XML code so I'm using ASP to dynamically create an XML page with the .xls extension just as if you would create an HTML page and it seems to work just fine. It's kind of a pain considering that one spread sheet can contain over 2,000 lines of XML code, but it requires no 3rd party software or com objects to do it.

Is that even close? Do you need more info?

[Mikeirv]

There is a much easier way to do this than the XML appraoch. try this in an asp file and you will see how simple it can be

<%
''// Set the name of the file that you are going to output
FileName = "MySpreadsheet.xls"

''// Build up a regular HTML table (this translates into the rows and cells in excel)
sData = "<table><tr><th>Name</th><th>Age</th></tr>"

sData = sData & "<tr><td>Mike</td><td>26</td></tr>"

sData = sData & "</table>"

''// Write out the table
response.write sData

''// Set the Header info
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader "content-disposition","attachment; filename=" & FileName
%>

If you want, you can put this into a function on your page. Then just make a link back to your page with a querystring that you can check and if it is there, run the function. If you run this, you will see that it prompts you to save the excel doc from the page. Just loop through your records to populate the rows and you are all set.