The file exported from TD is not in scientific notation. This reformatting when reading delimited text input is an Excel "feature". The only way I know of to avoid the reformatting is to concatenate a non-blank, non-numeric character to the exported field; but then the value is considered text rather than numeric.
Maybe a better approach to automate this would be to apply the formatting to a "template" spreadsheet and have Excel fetch the data from TD.
Thanks for the reply.
I cannot concatenate any character to the value since it is an important field. And i dont really understand this one 'apply the formatting to a "template" spreadsheet and have Excel fetch the data from TD.' I am exporting the file to excel with the help of a mainframe job. So i cannot make any changes in the spread sheet.
Teradata supports connections directly from Windows and Unix / Linux clients; Excel can use the Teradata ODBC driver as a data source.