troubleshooting Question

SQL Data in Excel

Avatar of bclivell
bclivellFlag for United States of America asked on
Microsoft SQL ServerVisual Basic ClassicMicrosoft Excel
7 Comments2 Solutions215 ViewsLast Modified:
Hi Everyone-

I am using excel(2003 and 2007 versions) to upload to and display informtion from a SQL(2005) table.  The SQL stores budget information.  There are two main identifers in the table: 1) a Service Code and 2) a specific Project Code.  When the person uses the excel file, they upload information regarding a specific project and they go to another sheet that shows totals from a number of different projects that correspond to that Service.  Right now to display the overall budget info, I have it set up like this:
     1) I excel bring in the entire SQL table (which has about 100 rows/60 columns of data
     2) Based on a project code field that that it is in a excel cell as well as the SQL table, I have a number     of "SumIfs" formulas to populate certain cells in excel that display the overal totals for different areas for that service based on the individual projects.

Needless to say, the excel file is getting very large.  Is there a way to have these "sumifs"/queries occur on the SQL side so the only information brought it is based on the "Service" code that is selected by the user.  Also, say I want cell C6 on the "Budget Summary" sheet to display the grand total for the Service from the Office Expenses column in the SQL table, is that possible?

I hope I made sense.  Thank you for your help, this is all new to me.  
Join our community to see this answer!
Unlock 2 Answers and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros