JC. wrote:
How can I execute this instruction TRANSACT-SQL with ADO in Excel and then
export it to excel. It is like a record but made with TRANSACT-SQL.
Is it posible???

Select Sum(contdiar.importe*contdiam.tasa * Case When contdiar.debito= 1
Then 1 Else -1 End )
From ContDiam Inner Join ContDiar on ContDiam.Id_Diam = ContDiar.Id_Diam
Where ...

JC.

I post a link to Microsoft site a few weeks ago, how to do this.
Try to find it.
ADO is not a T-SQL, but most of things can be done.
There is a bug in ADO which doesn't not allow to work on open files.
So if you want to read on write to the same file as your code it will
not work.