Hi there,

I have an Excel Spreadsheeet.

There is a cell containing a concatenated name and surname (don't ask why), for example:

Cell A2 BLOGGSJOE

On this cell, I would like to run the following SQL and output it to cell A3, A4 and A5

SELECT i.id, i.forename, i.surname FROM individual i  WHERE UPPER(REPLACE('" & A2 & "', ' ', '')) =  UPPER(REPLACE(i.surname|| i.forename, ' ', ''))  AND NVL(i.ind_efface, 'N') = 'N'

Any idea how I could perform an oracle query on each cell and return the result?

I have enabled an oracle datasource connection in Excel, just not sure what to do now.

Is this a stupid approach, and can you recommend a better more proficient way?

Thanks muchly! I lack the necessary experience in this type of thing! :-)

EDIT: I am aware that I could just write a simple ruby/php/python/whatever script to loop through the excel spreadsheet (or csv file), and then perform the query etc. but i thought there might be a quick way in excel itself.