Video : How to Export SQL Server Data to Excel

Leave a comment (1) Go to comments

Copying data from SQL Server to Excel is business requirement. Today I got this question by one of the blog reader, who wanted to learn "How to Export SQL Server Data to Excel"

Exporting data from SQL Server to Excel can be achieved in a variety of ways like

  • Data Transformation Services (DTS)
  • SQL Server Integration Services (SSIS) and
  • Bulk Copy (BCP)
  • Ad Hoc Distributed Queries

The easiest and simplest way to perform this task is to use the graphical wizard to export data from SQL Server to Microsoft Excel.

Step by Step Guide to export SQL Server Data to Excel


This video demonstrates how to use the SQL Server Import and Export Wizard to create a package that exports data from a SQL Server database to a Microsoft Excel spreadsheet

Related Information from Microsoft

Importing and Exporting Data by Using the SQL Server Import and Export Wizard
Exporting SQL Server Data to Excel


EOF - Video : How to Export SQL Server Data to Excel, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000
Leave a comment

1 Comments.

  1. Can tell how server to excel data transfer is done by Ad Hoc Distributed Queries ??

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.