Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using 2 cells in a table to retrieve data from another table | Excel Worksheet Functions | |||
Can Web Query retrieve a single HTML table cell? | Excel Discussion (Misc queries) | |||
VB.net/Excel/MSSQL Solution - Help! | Excel Programming | |||
New to VBS and MSSql | Excel Programming | |||
SQLRequest to MSSQL server - macro | Excel Programming |