Problem when importing data into Excel 2000 using MS Query Teradata ODBC connection
I'm trying to import data into an Excel 2000 spreadsheet by SQL query (using Data>>Get External Data>>New Database Query). However, I receive 'Out of Memory' followed by 'Could not read the file' when attempting to connect using the Teradata ODBC DSN.
I am able to connect to Teradata when using the same ODBC DSN in Teradata SQL Assistant 7.1 so I'm thinking that MS Query could be the problem. I've tried recreating the ODBC DSN with no luck.
I'm using Windows XP SP2 with version 220.127.116.11 of the ODBC driver for Teradata and Microsoft Office 2000.
Does anyone know if the Teradata ODBC driver is flakey with MS Query?