You could probably do this more simply by using ODBC (MSQuery) to the SQL
database like so

http://www.nickhodge.co.uk/gui/datam...taexamples.htm

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk


wrote in message
oups.com...
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