Sample Header Ad - 728x90

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 ...") enter image description here
Asked by Jonesome Reinstate Monica (3489 rep)
Nov 14, 2017, 04:54 PM
Last activity: Jul 7, 2022, 05:36 PM