wasn't this an earlier question? I responded that I wasn't able to do this :(
but I'm sure that there's a way to do it.
I even had the function inside an SP and that raised exactly the same error.



"michdenis" wrote:

Hi,

Is it possible to employ a user fonction in a query with ADO in Excel ?

If yes, is it possible to get a few examples which syntax should i used ?

For example, this one works :
SELECT Left(MyField,2) From .... But i can't integrate a personal fonction !

Any suggestion about a web site discussing of this subject is welcome.

Thanks for your time and your collaboration.