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?
stummjAsked:
Who is Participating?
 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.