Open Data from DW in MS Excel

Have data displayed from a db in Dreamweaver and need that data to be opened in MS excel. How do I call excel from dreamweaver to open the page in excel?

Grazie!

could you clarify what you need to do??

Do you want to generate an Excel compatible file (on the server, on the fly
from data in the db) that the website visitor will download and open in
their copy of Excel on their computers??

what scripting on the server, what db type?

Have data displayed from a db in Dreamweaver and need that data to be opened
in MS excel. How do I call excel from dreamweaver to open the page in excel?

yes. data dipsplyed on a web page and i want the user to be able to open it in
excel by a "open in excel link". on intranet and all users have it. we are
running on win 2000 and the database is in access. I am workign with ASP VB
script.

If you just need a single worksheet, it only takes one line of code.

At the top of your page, right after the <%@LANGUAGE bit, put
<%
Response.ContentType = "application/vnd.ms-excel"
%>

Then, be sure your data is in an HTML table. Unfortunately, Excel doesn't
support CSS, so you'll have to revert to the bad way if you want pretty
formatting.

There are other, more powerful methods if this one is too basic for your
needs. They just require more work, and I'm far too lazy for that.