Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-08-13 : 12:04:11
|
| Paul Brandon writes "Greetings. We currently have a Cold Fusion (http://www.macromedia.com/software/coldfusion/) web-based application that runs with an Oracle back end on our own server. We use another application called Chili Reports (no longer supported) to dynamically export Oracle table data to an Excel file that opens up in the person's browser when they click a link on the page.We are migrating our application to a SQL Server 2000 back end on a commercial ISP's server and would like to maintain for our users the ability to receive a dynamically generated file in either Microsoft Access or Excel format---either a copy of the raw SQL Server table or, much more desirable, the results of a particluar query.I think I know how to do this "at the console", however, is there a way to do this via a web link??? Note that we probably will not have "shell" access (although I have access to Enterprise Manager).Thanks for any insights!Paul." |
|
|
|
|
|
Exporting a SQL table to an Access/Excel file dynamically via weblink