SQL 2008

[f5mann]

using excel and odbc function - I need to be able to pull out info and create reports. I viewed the administrator course but did not find my requirements listed. I guess the correct terminology would be SQL reporting but not sure? We are using SQL 2005 which I do not believe to be an issue with learning what I want to learn. Again not sure?

Thank you

F5mann

[Space1202]

Was anyone able to respond with an answer to this question?
http://www.thepictureshare.com/img/4/B.jpg

[Lisa]

Mel has been out of town, but I will make sure he sees this question when he gets back.

[Mel]

Hello F5mann
Are you asking "Is it in the admin course?" or are you asking "How would I do it?"
If you are asking is it in either of the SQL courses the answer is no. That's out of scope. I'd love to do a course that gets into SQL Server client connectivity issues, but we aren't there yet.

If you are asking "How would I do it?" there are a zillion ways to connect using ODBC.
I would suggest starting with this site.
http://msdn.microsoft.com/en-us/library/ms131326.aspx
Establishing an ODBC client connections is kind of generic in that if you get for C#.Net, vs. VB.Net, vs. Excel, vs. ... then you basically got it.
;)