Hi viacheslav.gorelik,

have you been able to pass a parameter to the udf function that way ? my sql function works fine in Excel when the Command text in the Connection Properties is like this:

select * from fnMyInlineTableFunction ('123456')

but I can't find a way to male it use a parameter (read from a cell in the excel file for instance), something like:

select * from fnMyInlineTableFunction (?)

thanks,

andrea