Query SQL 2005 Views with Excel

[Jon von der Heyden]

Hi

I've posted this on Experts Exchange too, specifically trying to target the SQL Server experts. http://www.experts-exchange.com/Sof...Office_Suites/MS_Office/Excel/Q_24423637.html

SQL Server isn't really my thing. I have been asked to quote on a job to build some models. One of the components is to pass parameters to sql server views and return the data into a table in Excel. I never done this.

1. Is it possible to pass parametrs to a view thru Excel?
2. Will the view execute based on the users permissions (different users using the Excel template have different access rights)?
3. Any other things to consider?

I don't need specific solution, only really some broad advice. I really only want to know how feasible this is...

Thank you

Hoping some MrExcel members may be able to provide advice too.

 

[RoryA]

But only when the wife isn't looking, huh

Doesn't count if it's work!