Excel and SQL Server - Book?

[RJ]

I am looking to integrate Excel and a back end MS SQL Server database.

The database is running on MS SQL server and has statistical information
for help desk agent call stats. I want to create a spreadsheet that can query
the database and provide certain information about agent stats, to our agents.
Something the agents can use to keep up to date with their performance.

I have a general idea of how to do this, but am looking for an Excel
book that can assist me with this. Something beyond the basic,
and with some depth in SQL database integration. (Note: I am not a programmer,
but have have some programming and scripting experience).
The book doesn't have to be *just* about this topic, but does need to
cover it in some depth.

Does anyone have any suggestions? (Excel 2003 and SQL Server 2000)

 

[Nick Hodge]

RJ

I would suggest any Excel book that covers pivot tables in detail as the
external source for this makes little difference.

If it's the SQL bit you need training on then you may need two books, but
undoubtedly you'll need a pivot table to report this to your agents

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England

(e-mail address removed)
www.nickhodge.co.uk

 

[RJ]

Thanks for the input. After spending some time at Amazon,
I found a couple of books that go into detail about accessing/using
external data sources (i.e. databases) that should give me what I need.