Tags for microsoft query
How many Teradata sessions does Micorsoft Query use?
Hallo, does somebody know how many session/sqls MS Query sends over ODBC to teradata? Currently I refresh an Excel Pivot (with external Data on Teradata) with a VBA script and it takes very long time and on teradata I see a lot off sessions... I don't understand why. The second quession is: Can I optimze the request? Thanks a very lot Markus PS.: That's a part off the VBA-Code: SQLtxt = ActiveWorkbook.Sheets("SQL - Pivot").Cells(2, 1).Value Sheets("BOOK1").Select Range("PIV").Select
odbc sql excel ms query microsoft query