Excel AS400 ODBC Parameter - Comma Separated List

Delfinus25

Board Regular
Joined
Feb 27, 2016
Messages
80
I am connected to an AS400 database using Microsoft Query iSeries ODBC.

I want to use a parameter and allow the user to put in a list.

i.e. where x.Store NOT IN (003,006,008)

I tried entering a parameter (?) here, and referencing a cell, but I keep getting a length error.
How do I allow the user to input this list when I don't know how long / how many stores it will contain?
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Watch MrExcel Video

Forum statistics

Threads
1,102,292
Messages
5,485,980
Members
407,523
Latest member
Talicius

This Week's Hot Topics

Top