get a result of an sql statement in a field ?

  • Thread starter Thread starter Ralf Meuser
  • Start date Start date
R

Ralf Meuser

Hi there

I have an Excel sheet with many lines of data.
I would like to know if there is a possibilty to create a field which will
execute an sql-statment on an MSsql Database
and will return the result. Some thing like (select name from address where
uid=$B5)

Thanks in advance for any help


Ralf
 
I found out that the statement sql.request should do it.
But where can I find the addin for Excel 2003

Thanks in advance

Ralf
 
Back
Top