Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA and SQL Server 2000 UDF
Hi All,
Can I get SQL Server 2000 UDF (user defined function) returned value by using Excel VBA? If I can, please provide a simple example. I am using Excel 2000 Many thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA and SQL Server 2000 UDF
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA and SQL Server 2000 UDF
Hi Jamie,
Thanks for reply. I know how to work with Stored Procedures in SQL Server (by using OUTPUT parameters)to get returned value (scale value), what I am interested is, how or if is possible to get returned value from a SQL Server UDF by using Excel VBA, just we get returned value from Excel VBA UDF? Yesterday I read some interesting stuff, suggest we CAN NOT get returned value from SQL Server UDF, I wonder is this true? I would be surprised to know we have to treat SQL Server UDF just like SQL Server Stored Procedures - if this is the case, why we need UDF? Thanks. Kind Regards, Charles (Jamie Collins) wrote in message . com... (Charles) wrote ... Can I get SQL Server 2000 UDF (user defined function) returned value by using Excel VBA? Wrap the function in a stored procedure, call the stored proc from VBA code using ADO. Jamie. -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2000 on Windows Server 2003 | Excel Discussion (Misc queries) | |||
How to Transfer data from Excel to SQL SERVER 2000 | Excel Discussion (Misc queries) | |||
i want to connect excel with sql server 2000 as database with macr | Excel Discussion (Misc queries) | |||
calling a stored procedure on MS SQL Server within MS Excel 2000 | Excel Programming | |||
Terminal Server 2003 + Excel 2000 | Excel Programming |