Excel and SQL Server - Book?

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)
"RJ" <jackbobNOSPAM@.hotmail.com> wrote in message
news:%23XPx99F8GHA.4776@.TK2MSFTNGP02.phx.gbl...
> 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)
>
Are you planning to use DQY files inside of Excel or something else?
|||I think you're looking at the wrong app as a front-end. Better to use
Microsoft Access
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"RJ" wrote:
|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)
|
|
|||As you may already know, Excel has some built-in database linking/querying
capability (accessed from menu "Data"). From there you can build queries to
get data from SQL Server. However, programming will give you more
flexibility. You can choose VBA, Excel COM Add-in or .NET add-in developed
with VSTO. Among them VBA is easiest IDE and built right in the Excel. So,
find some book on Exce VBA, or simply Excel's VBA help may good enough to
get you started.
"RJ" <jackbobNOSPAM@.hotmail.com> wrote in message
news:%23XPx99F8GHA.4776@.TK2MSFTNGP02.phx.gbl...
>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)
>
|||BTW, you may get better responses if posting to "microsoft.public.excel.*"
groups.
"Norman Yuan" <NotReal@.NotReal.not> wrote in message
news:eQYKU7G8GHA.3916@.TK2MSFTNGP04.phx.gbl...
> As you may already know, Excel has some built-in database linking/querying
> capability (accessed from menu "Data"). From there you can build queries
> to get data from SQL Server. However, programming will give you more
> flexibility. You can choose VBA, Excel COM Add-in or .NET add-in developed
> with VSTO. Among them VBA is easiest IDE and built right in the Excel. So,
> find some book on Exce VBA, or simply Excel's VBA help may good enough to
> get you started.
> "RJ" <jackbobNOSPAM@.hotmail.com> wrote in message
> news:%23XPx99F8GHA.4776@.TK2MSFTNGP02.phx.gbl...
>
|||Thank-you very much for the information.
"Norman Yuan" <NotReal@.NotReal.not> wrote in message news:eQYKU7G8GHA.3916@.TK2MSFTNGP04.phx.gbl...
> As you may already know, Excel has some built-in database linking/querying capability (accessed
> from menu "Data"). From there you can build queries to get data from SQL Server. However,
> programming will give you more flexibility. You can choose VBA, Excel COM Add-in or .NET add-in
> developed with VSTO. Among them VBA is easiest IDE and built right in the Excel. So, find some
> book on Exce VBA, or simply Excel's VBA help may good enough to get you started.
> "RJ" <jackbobNOSPAM@.hotmail.com> wrote in message news:%23XPx99F8GHA.4776@.TK2MSFTNGP02.phx.gbl...
>