Export Data from Teradata to Excel Spread sheet
Please find below my requirement.
- Need to get data from Teradata and the result should be automatically pulled to an excel sheet.
- A shell script should perform the above operation.
Right now I have connected to Teradata using shell script, not sure how I can pull the results to an excel sheet.
Your best bet is to export the result to CSV file. A Direct export to Excel is not supported.
.LOGON localtd/dbc,dbc; .EXPORT FILE = C:\TX\out.txt; .SET RECORDMODE OFF; .SET INDICDATA OFF; .SET SEPARATOR ',' DATABASE databasename; SELECT * FROM tablename; .LOGOFF .EXIT