How do I generate a report from SQL to MS Excel?

Question

1.00/5 (1 vote)

See more:

SQL-Server-2014

Hello,

Is there a way to have the SQL results be exported to MS Excel Automatically?

Normaly, we execute the SQL command and once the results are display we right click on the result set and select either Copy or Copy with Headers and paste it on MS Excel.

Thanks in advance

Posted 29-Oct-14 5:32am

mahdear

Add a Solution

Comments

PIEBALDconsult 29-Oct-14 11:54am

SSIS?

mahdear 29-Oct-14 13:14pm

its more on SSMS.. will SSIS create a CSV or XLX file when I run the SQL code?

PIEBALDconsult 29-Oct-14 16:27pm

If that's what you tell it to do.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Peter Leow · Answer 1 · 2014-10-29T05:37:00

Solution 1

Check this out: export data from SQL Server to Excel or any other Format[^]

Posted 29-Oct-14 5:37am

Peter Leow

Comments

Maciej Los 29-Oct-14 13:10pm

+5

Peter Leow 29-Oct-14 21:54pm

Thank you, Maciej.

Maciej Los · Answer 2 · 2014-10-29T07:24:00

Solution 2

Alternativelly...

You can connect to SQL database using MS Excel functionality. Please, have a look here: Excel: Connect to (import) SQL Server data[^]

Posted 29-Oct-14 7:24am

Maciej Los

Comments

Peter Leow 29-Oct-14 20:44pm

5ed!

Maciej Los 30-Oct-14 2:48am

Thank you, Peter ;)