Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 493
  • Last Modified:

Extracting Selective Oracle Data Into Excel

I have an excel spreadsheet and want to lookup some columns from an oracle database. ODBC is working fine.

To simplify the problem I have data in column A and to lookup data based on this column to appear in column B and C

So for example I may have....

XCEL COL A
APPLE
ORANGE

ORACLE TABLE FRUIT
COLUMN 1 = FRUIT NAME
COLUMN2 =  CITRUS_BOOLEAN

I want to do a lookup so that the spreadsheet ends up like this

COL A        COL B
APPLE           FALSE
ORANGE       TRUE

Column B is a lookup on Oracle based on the value of Column A

Is this possible?
0
stummj
Asked:
stummj
  • 2
1 Solution
 
Rory ArchibaldCommented:
I suspect the most efficient way would be to have a querytable import the values from the table and then use a lookup. Otherwise, you would have to use a user defined function with ADO to retrieve the value from the Oracle table which might involve a lot of network traffic.
Regards,
Rory
0
 
stummjAuthor Commented:
Hmm not really practical because of various reasons, but thank you for trying. Its obviously a no!
0
 
Rory ArchibaldCommented:
If you have the XLODBC.XLA add-in (you can download it from MS), then you can use the SQL.REQUEST worksheet function, which I think works with Oracle. You can also do it with VBA and ADO.
Regards,
Rory
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now