How to create excel export using sql query? [duplicate]

Question

I need help in export data from table to excel file using sql query. and with header and footer.

I used master..xp_cmdshell with passing db name, table name, and path where I store excel file any buddy can solve this. and any other way like query through export data to excel.

I must say I want to solve problem using query only. because I require only query.

I must say I can solve problem using query only. because I require only query. - when you can solve your problem, then why asking here? Maybe you should make your problem clearer — bish
– bish, Commented Dec 29, 2014 at 6:09

JohnS · Accepted Answer · 2014-12-29 06:19:11Z

0

If you need column headers the best way to export to a CSV file (which EXCEL will open) is by using sqlcmd. The syntax is something like:

c:\>sqlcmd -S servername -i c:\path\yourqueryfilename.sql -o C:\OutputPath\AFilename.csv -s","

See http://msdn.microsoft.com/en-us/library/ms162773.aspx to find the complete command line options available for SQLCMD.

answered Dec 29, 2014 at 6:19

JohnS

2,0581 gold badge14 silver badges16 bronze badges

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

Collectives™ on Stack Overflow

How to create excel export using sql query? [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related