Thursday, February 15, 2018

Excel - Filter Data Connections with Values in Sheet

https://stackoverflow.com/questions/14346563/excel-send-multiple-values-in-command-text



  1. Get Date>From Other Sources>Use Microsoft Query
    1. DO NOT USE Connect to SQL
  2. In the SQL, use ? to define parameters
  3. Select a field on the sheet to be used for the parameter value when prompted

No comments:

Post a Comment