How to generate a csv file using select query in SQL [duplicate]

Question

Possible Duplicate:
How to export data as CSV format from SQL Server using sqlcmd?

I want to generate CSV file using select query in SQL-server.

The code below is working correctly in mySQL:

select * into outfile 'd:/report.csv' fields terminated by ',' from tableName;

It generated the CSV file.

Does anybody know how can I create a CSV file using select query in SQL-server?

There is a SSMS 2008 addin tool that does this for your tables that can be customized by where and order by clauses. store.nmally.com/software/sql-server-management-studio-addons/… — user975249
– user975249, Commented Jul 14, 2013 at 6:33

Rahul · Accepted Answer · 2011-07-21 13:50:50Z

15

Will this do the work

sqlcmd -S server -U loginid -P password -d DBname -Q "select * from tablename" -o output.csv

EDIT:

Use -i options if you want to execute a SQL script like -i sql_script_filename.sql

answered Jul 21, 2011 at 13:40

Rahul

78.1k14 gold badges80 silver badges132 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

anon · Accepted Answer · 2013-06-12 14:46:00Z

1

SQLCMD -S MyInstance -E -d sales -i query_file.sql -o output_file.csv -s

You can use OPENROWSET() to read from a CSV file within a T-SQL query but AFAIK you can't write to one. This is really what SSIS/DTS is for.

If you're working with it interactively in SQL Server Management Studio you could export a grid to a file.

anon

4,2323 gold badges31 silver badges26 bronze badges

answered Jul 21, 2011 at 13:41

Yuck

51.1k13 gold badges108 silver badges136 bronze badges