Question: how to export data from teradata to excel file?
Answer: Make sure you have the columns in Excel in the same order as the table you created. ...  In SQL Assistant set the Delimiter as ","(comma) . ...  Go to "Tools=>Options" and select the Date Format as 'YYYY-MM-DD'. ...  From Teradata SQL Assistant, click 'File', then 'Import Data'.