Post reply

SQL View into Excel 2010 - enter criteria within Excel?

  • September 13, 2012 at 6:04 am

    #261793

    Hello all

    I have a SQL view linked into an Excel sheet.

    I was wondering if it is possible to programme a macro that would allow you to choose criteria in Excel and will then extract the view with the entered criteria.

    For example: by entering a month in a cell in Excel, the SQL datasource will extract only records in that month.

    Does that sound possible?

    Thanks in advance

    Peter

  • September 15, 2012 at 8:48 am

    #1538275

    maybe this will give you some ideas

    hope it helps

    http://www.csharpest.net/?p=117

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

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

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