Re: query Oracle using excel data reference

You can use SQL*XL to do this.

SQL*XL can be found at http://www.oraxcel.com

If you had your customer name in say A1 you would do:

select * from cust_table where custname = :A1

Now you can name A1 mydata if you like. That would then need the SQL:

select * from cust_table where custname = :mydata

If you want to run the IN scenario you'd have to comma separate the possible values into a form like this:

select * from cust_table where custname in (:A1,:A2,:A3)

Hope this helps,

Gerrit-Jan Linker

In article <3A781325.9C75B951_at_hotmail.com>,   yabba-dabba-doo <fnfj_at_hotmail.com> wrote:
> I can connect in Excel to a schema and use MS query to return data.
> What I'd really like to do is have various custnames in
> cells of column A of excel defined as mydata and have MS Query do
> select * from cust_table where custname in mydata.
> Is this possible?
> Peter
>

Sent via Deja.com
http://www.deja.com/ Received on Fri Feb 02 2001 - 10:38:22 CST