Comments
Sort by recent activity
Thanks for your reply Jon. Copy with headers is not great options because often my data has CR/LF in it, which does not work well. Save as CSV does work decently, but the formatting is different than if I am able to just open in Excel. A Save as XLSX would be a great option. That being said, I think I found an interesting workaround by first opening the admin version of SSMS, then opening SSMS under my normal account. For whatever reason it now allows me to Open in Excel with the normal user, even though I am in the admin version of SSMS. / comments
Thanks for your reply Jon.Copy with headers is not great options because often my data has CR/LF in it, which does not work well. Save as CSV does work decently, but the formatting is different tha...