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
|