Post reply

Best way to get SQL Server 05 query results into Excel

  • March 23, 2011 at 12:33 pm

    #99283

    I have a few queries that I need to make available to non-IT end users. Need to have them input a few simple parameters - date range, other filters - and pass those to a query, and return the results into an Excel spreadsheet. I know we can run queries directly in Excel - but looking for suggestions on how to make this simpler for end user. A simple vb/asp app? Web app/php? Not afraid to build something - but if there are already programs available, would welcome suggestions.

    Thanks!

  • March 23, 2011 at 1:34 pm

    #1302683

    How about a parameterized query run in Excel? Make the first couple of rows be for entering the parameters (Start Date, End Date, etc.), then pass to the query to be run.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply