SQL Server: SSMS "Save Results As" creates CSV that Excel mangles
3
votes
6
answers
18849
views
Using the Save Results As option, shown below.
CSV looks good!
But when Excel opens/imports it:
- Long strings are mangled as numbers (if the data is largely numeric)
- Dates are not detected properly
- My users beef about all this
How do I get a query to a clean excel file (a real xls/xlsx) without dancing? (We like everything to actually in the SQL file itself... I wish we could do "SELECT INTO FILE:C:\SQLOUTPUT\DATA.XLS ...")

Asked by Jonesome Reinstate Monica
(3489 rep)
Nov 14, 2017, 04:54 PM
Last activity: Jul 7, 2022, 05:36 PM
Last activity: Jul 7, 2022, 05:36 PM