I'm trying to find the fastest way to actually get SQL Server query results to Excel, with the least possible trouble.
Frankly the query > text is a bit annoying, there's a "9393 results found" at the bottom. There's also a character limit of 8,000.
The query > grid looks nice, but it either exports (copy>paste) with no delimiter whatsoever, or defaults to commas with (save as) - which doesn't work for data containing natural commas.
Is there any way to do grid export > with semicolons or custom deliminator?
Not sure why SQL Server likes to make this as annoying as possible, there are many MySQL clients that make this simple.