+ Reply to Thread
Results 1 to 2 of 2

External query where parameter is a sheet cell

  1. #1
    Hall
    Guest

    External query where parameter is a sheet cell

    I want to run an SQL to an external database source where the parameter of
    the query is specified in a sheet cell. For example:
    select amount
    from mynumbers
    where id=C5

    where C5 is a sheet cell and has the id value to index.

    Is this possible? What's the syntax?



  2. #2
    Nick Hodge
    Guest

    Re: External query where parameter is a sheet cell

    Hall

    Check out here

    http://www.nickhodge.co.uk/gui/datam...taexamples.htm

    --
    HTH
    Nick Hodge
    Microsoft MVP - Excel
    Southampton, England
    nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS

    "Hall" <hall@garp.org> wrote in message
    news:OvI3UOfQFHA.3120@TK2MSFTNGP10.phx.gbl...
    >I want to run an SQL to an external database source where the parameter of
    > the query is specified in a sheet cell. For example:
    > select amount
    > from mynumbers
    > where id=C5
    >
    > where C5 is a sheet cell and has the id value to index.
    >
    > Is this possible? What's the syntax?
    >
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1