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

How to recognize a fake Geek Squad renewal scam | Consumer Advice

Except from Scammers are at it ag...