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

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

Watch MrExcel Video

Forum statistics

Threads
1,099,684
Messages
5,470,114
Members
406,681
Latest member
sachinmasurkar

This Week's Hot Topics

Top