I would like the user to be able to click a button on the web page that will run a SQL query (canned report) and export the result data to an Excel spreadsheet. The data does not need to display on ...
How-To Geek on MSN
Microsoft Excel isn't a database, please stop using it like one
Excel offers no such constraint. If someone is determined to enter bad data, they can simply paste values over a validated range or open the file in another program to completely bypass the rules I ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results
Feedback