Tags for ms query
"Invalid date supplied for" error
My database is a Teradata version I retrieve data with a MS Excel v2003 file (using MS Query) Before to do that, I installed "the tdodbc__windows_i386." products on my desktop : Teradata Client 13.10, Teradata ODBC driver. I created a System DSN etc.
odbc date format ms 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