That solution concerns me. What else can the Excel user access from the database? Just the view, or other elements as well? Surely if the database is not open for anonymous access, that means that data contained therein is meant to be private. Snooped or not, this seems like a huge risk to take with the customer data.
Would some form of DHTML/Javascript solution work better? ie. get the data into the browser (embed the view to produce js statements or a data island), and then launch Excel from there, passing the data over. That way, your seperating Excels use of the data from the server.
That solution concerns me. What else can the Excel user access from the database? Just the view, or other elements as well? Surely if the database is not open for anonymous access, that means that data contained therein is meant to be private. Snooped or not, this seems like a huge risk to take with the customer data.
Would some form of DHTML/Javascript solution work better? ie. get the data into the browser (embed the view to produce js statements or a data island), and then launch Excel from there, passing the data over. That way, your seperating Excels use of the data from the server.