I feel like this question is so simple I shouldn't have to ask it, but here goes.
我觉得这个问题很简单,我不应该问它,但是这里有。
I have a query in Microsoft SQL Server 2017 Management Studio, I want the results to be in Excel. How do I make that happen?'
我在Microsoft SQL Server 2017 Management Studio中有一个查询,我希望结果在Excel中。我怎么做到这一点?'
Update: apparently I have to clarify that I know how to copy and paste data. I am trying to actually update Excel with my query so that I do not need to constantly open SQL Server Management Studio.
更新:显然我必须澄清我知道如何复制和粘贴数据。我试图用我的查询实际更新Excel,以便我不需要不断打开SQL Server Management Studio。
1 个解决方案
#1
0
First link in google (export query result to excel SQL Server management 2017)
谷歌中的第一个链接(导出查询结果以超越SQL Server管理2017)
http://developmentnow.com/2008/04/07/sql-server-management-studio-export-query-results-to-excel/
#1
0
First link in google (export query result to excel SQL Server management 2017)
谷歌中的第一个链接(导出查询结果以超越SQL Server管理2017)
http://developmentnow.com/2008/04/07/sql-server-management-studio-export-query-results-to-excel/