This code example demonstrates how to create excel documents on your server. Using the US state info db, after reading the contents of the db instead of writing output to the browser, html text is written to the server with the .xls file extension. A link to the new document is created (in the browser) for easy navigation to the new document. The current time (server time) is also displayed to show that the excel document was created dynamically.
Version: n/a Platform(s): n/a Updated: Thu Jun 7 2001
The connection string in this example is outdated. Should be: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("dbname.mdb"). Once I did that, the rest flowed well. Good script and I use it currently.
Chris
Create Excel on the Server, Mar 29, 2005
Reviewed By:
shadowspell
