Wednesday, March 29, 2023

Exporting data from SQL Server Express to CSV (need quoting and escaping)

(Monday, October 5, 2015)

In SQL Management Studio, right click the database and select Tasks -> Export Data.

Then choose SQL Server as the source and Flat File as the destination. Name the file MyFile.csv.

Set the Text qualifier as "

Select 'Write a query to specify the data transfer' and paste in your query. You can leave the next settings as the defaults.

With the data exported, open with Excel and save in the Excel format.

No comments:

Post a Comment

GPG Verify DupeGuru

https://dupeguru.voltaicideas.net/ https://github.com/arsenetar/dupeguru/releases/tag/4.3.1 $ gpg --verify dupeguru_macOS_Qt_4.3.1.zip.siggp...