Thank you for this, simple solution to a problem I heretofore found only complex recommended solutions.īack To Top - what version of SQL Server Management Studio are you using? Great tip, but when you have large result sets (I had 70k results), the data columns get skewed. I tried the option given by you- going to Query option and selected header checkbox but it's not helping me. However, it'll pulls the data but without column header. I'm using macro to pull the data from SQL server Management Studio. If you are using a later version of SSMS you can right click on the results grid and select copy with headers. And hence, I need your suggestion as what I need to add in the macro so that it'll fetch the data with header in excel? I'm not directly copying the data from excel sheet hence this option will not work here. However, I would like to inform you that I'm trying to fetch the data from MS SQL server to Excel sheet through Macro. Take a look at this to see if this could help: Not exactly sure how you can do that through Excel.
It would be nice if I could do the same thing with column headings. Is it possible to turn headings on or off without using the Query Options dialog?
