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]

1. Yes!
2. Depends on your connection string really.
3. Don't know - I'm not a dba.

 

[Jon von der Heyden]

Ah so it should be feasible. Thanks Rory.

Re: 2, do you mean I can pass the username thru the connection string?

 

[RoryA]

You can specify a db username (like sa) or you can specify using windows user ids - details here.

 

[Jon von der Heyden]

Excellent! Thanks again. Perhaps I should contract the assignment to you.

 

[RoryA]

You could, but I'm very expensive!

 

[Jon von der Heyden]

You mean you wouldn't just do it for the fun of it?

 

[RoryA]

Afraid not - my minimum hourly rate is 4 Guinnesses...

 

[Richard Schollar]

But only when the wife isn't looking, huh

 

[Jon von der Heyden]

Afraid not - my minimum hourly rate is 4 Guinnesses...

Oh I think I might afford that... Although I'm not sure you'll get any work done... No change there though