CODEWITHSUNDEEP
teradata
user3803261
user3803261

Reputation: 31

export result into excel sheet from teradata sql assistant

I want to export the results into excel sheet by running the query in Teradata SQL Assistant. I used copy paste but it didnt work Thanks in advance.

Upvotes: 2

Views: 55799

Answers (2)

user5952841
user5952841

Reputation: 11

Select the whole excel worksheet you will paste into and set the number format to 'text'.

Now you can safely copy the data from the teradata sql assistant's query results and paste them into the spreadsheet.

Upvotes: 1

Rob Paller
Rob Paller

Reputation: 7786

If you return the answers to SQL Assistant you should be able to select Save Answerset from the File menu. You will then have the option to save it as a proper Excel file format.

If you export the answers to a flat file directly the delimited text file can in turn be opened with ease in Excel and then saved as a proper Excel file format (XLS, XLSX, etc.)

Upvotes: 5

Related Questions