View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] tek.hong@gmail.com is offline
external usenet poster
 
Posts: 4
Default How to retrieve value from MSSQL table into a cell

Hi all

Is it possible to develop a custom function that I could use to
retrieve a field value from a MSSQL database into a cell?

Example # 1

@DBSEEK('00001','Customer','Name')
which would retrieve the custome name of customer ID, 00001 from the
customer table in a MSSQL database.

@DBSUM('Employee','Salary','Department=[ADMIN]')
which would get the sum of salaries of all employees of
department="ADMIN" from the employee table of a MSSQL database


Your advice most appreciated

Best Regards