If you understand ADO then you could write a custom function to do what you
need.
You might have to spend some time parsing the parameters to create the SQL
though, depending on how generic you need it to be.

Tim

--
Tim Williams
Palo Alto, CA


wrote in message
oups.com...
Thanks Nick

Is there a way I could automate this by writing a VBA function that
will access the MSSQL table programatically? Your advise most
appreciated. Thanks

Best Regards


Nick Hodge wrote:
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