Excel with Stored Procedures
"http://www.sqlservercentral.com/articles/Stored+Procedures/63537/ Printed 2008/12/03 07:16AM Excel with Stored Procedures By David Poole, 2008/06/25 Excel with SQL Stored Procs Introduction A colleague asked how I felt about making a user a member of db_datareader on a server used by non-DBAs for reporting data. The server exists precisely to allow people to write ad-hoc queries without threatening live systems. He then went on to say that they were using Microsoft Excel to query the data and that this was in the requirements for the project he was working on. He was asking the question because his technical specification said that Excel would query the data by calling stored procedures but the end user said that this wasn't possible without writing reams of VBA macros. Using Microsoft Excel is a bit off my radar but I thought I would investigate. I'm using Excel 2000, it works, I'm comfortable with it, it does everything I want so why upgrade? Basic queries with Exce...