导出sql server结果窗格以打开办公室 [英] export sql server result pane to open office

问题描述

任何人都可以告诉我如何使用查询或任何其他方法导出sql server结果集以打开办公室表格.plzzz
在此先感谢...

can any one tell me how to export sql server result set to open office sheet using query or any other method.plzzz
Thanks in advance......

推荐答案

如果您需要手动解决方案，请在SQL Management Studio中运行查询，然后像通常那样将结果放入网格中然后在网格中右键单击并选择另存结果为"，然后另存为CSV文件并在openoffice中打开.

If you want a manual solution, run your query in SQL Management Studio and have results go to grid like you probably normally do and then right-click in the grid and choose Save Results As and then save as a CSV file and open in openoffice.

这篇关于导出sql server结果窗格以打开办公室的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！