Thread: ADO-SQL-Excel
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JC. JC. is offline
external usenet poster
 
Posts: 1
Default ADO-SQL-Excel

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.