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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

get a result of an sql into a field 1
Printing SQL query results in a list of columns, instead of one long column 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Help with SQL Statement for pivot table 2
Excel Create a New line in a Word Link without double "" around result 0
INDEX/MATCH -> having issues getting to grips with it 4
SQL in Excel data 4
SQL statement not returning any records 1

Back
Top