Function to return Oracle result

[beatdown]

Hello,

I am big on PHP, but know little about VBA. This is what I need:

A function that connects to a oracle database, does a query, an
returns the result. This function is intended to be used where th
result will be one record of one field.

For example, I have a list of account numbers in one column. I want
function in column two to return the name associated with that accoun
number. (The table being queried will have a few million records t
sort through, importing the data is not a solution).

I need the function to be a vehicle for this SQL statement:

SELECT X FROM Y WHERE ACCOUNT = Z

Where X (field name), Y (database name), and Z (info) can be frovide
by the user. Maybe function GetResult(X,Y,Z). That way it coul
reference cells. The function should return the result.

Is this difficult? Am I being clear?

Thanks

 

[onedaywhen]

The SQL.REQUEST function is probably what you want.

 

[beatdown]

Yes, I found that out today. Thanks for taking the time