Cowmaster's Corner
Simple answers. Now.
Thursday, February 15, 2018
Excel - Filter Data Connections with Values in Sheet
https://stackoverflow.com/questions/14346563/excel-send-multiple-values-in-command-text
Get Date>From Other Sources>Use Microsoft Query
DO NOT USE Connect to SQL
In the SQL, use ? to define parameters
Select a field on the sheet to be used for the parameter value when prompted
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment