0 - 2 of 2 tags for ms query

My database is a Teradata version 13.00.01.19
I retrieve data with a MS Excel v2003 file (using MS Query)
Before to do that, I installed "the tdodbc__windows_i386.13.10.00.05" products on my desktop : Teradata Client 13.10, Teradata 13.10.00.05 ODBC driver. I created a System DSN etc.

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