将结果从teradata sql助手导出到excel表中

问题描述:

我想通过在 Teradata SQL Assistant 中运行查询将结果导出到 Excel 表中.我使用了复制粘贴,但没有用提前致谢.

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.

如果您将答案返回给 SQL Assistant,您应该能够从文件"菜单中选择保存答案集".然后,您可以选择将其另存为正确的 Excel 文件格式.

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.

如果您将答案直接导出到平面文件,则可以在 Excel 中轻松打开分隔文本文件,然后将其保存为正确的 Excel 文件格式(XLS、XLSX 等)

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.)