parameter-driven query

  1. dbig

    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...
    • dbig
    • Thread
    • named range in odbc sql odbc excel driver odbc query parameter-driven query parameters with ?
    • Replies: 4
    • Forum: Excel Questions
  2. K

    VBA to SQL query with parameters

    I am trying to write an SQL query using parameters in an Excel Worksheet and then return the results to the current sheet ar cell B11. I have found it imposible to make it work in SQL so am trying to run it from VBA to pass the parameters. These are named cells StartDate and EndDate in...
  3. C

    query parameters - EXCEL 2010

    I have a workbook that contains two sheets with two seperate queries. On the first sheet I have two cells desiginated to accept the values for the parameters. The first sheet accpets the values and populates the table correctly. The second sheet doesn't seem to accept the values and just...
  4. O

    sql query from Excel using range

    I am given a spreadsheet with a column of item numbers that changes each week. I need to take those item numbers and compare them to the same data in another database. I can connect to the database AS400(DB2) fine and return single rows of data. Rather than using the three options from the query...
  5. KG Old Wolf

    VBA parameter query syntax error

    All, I need a fresh set of eyes... I just can't see the issue with the first "with" line of code (connection string). I am attempting to write my first "parameter-driven" query in VBA. Thanks for any suggestions.... Sub qry_Divsions() ' ' ' Parameter driven query to extract specific...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top