Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> query Oracle using excel data reference

query Oracle using excel data reference

From: yabba-dabba-doo <fnfj_at_hotmail.com>
Date: Wed, 31 Jan 2001 13:29:09 +0000
Message-ID: <3A781325.9C75B951@hotmail.com>

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 Received on Wed Jan 31 2001 - 07:29:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US