Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Parameters In External ODBC Data Queries - "is one of"
I want to qry an access table and display results in excel. parameters for
the criteria to be set in excel. I have followed the Nick Hodge write-up (http://www.nickhodge.co.uk/gui/datam...taexamples.htm) and that works fine so far. But: one of the criteria is a "In(list)". I want to receive all records where field A is one of (USA, Mexico, Canda) Question: what syntax must I use for the value list in the parameter field in Excel? (have tried separated by blanks, comma, comma+blank, enclose in singel quote, double quote - but no success so far. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Web Queries and how Excel sees the "selected box" on the web page | Excel Discussion (Misc queries) | |||
Excel Service error "cannot connect to external data source" | Excel Discussion (Misc queries) | |||
Parameters in SQL queries using "contains" or "like" | Excel Discussion (Misc queries) | |||
Yahoo + "Get External Data" | Excel Worksheet Functions | |||
How can I globally set "error message" parameters in Excel | Excel Worksheet Functions |