odbc query

  1. D

    Excel AS400 ODBC Parameter - Comma Separated List

    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...
  2. D

    Entering multiple values to ODBC sql WHERE clause as a single parameter

    I have a workbook that pulls data from several oracle tables (same database) based on a common key value or values. Using the Query wizard, I build the core query ... "select * from Table1 where KEYVAL = 'C1234'". Next, I go into Data/Properties, then Connection Properties and convert the...

Some videos you may like

This Week's Hot Topics