将结果从teradata sql助手导出到excel表中 [英] export result into excel sheet from teradata sql assistant

问题描述

我想通过在 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.)

这篇关于将结果从teradata sql助手导出到excel表中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！