top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How to export data from Sql Server to MS Excel?

+10 votes

I have 15-20 tables and i want to export the data from those tables to excel.

posted Feb 6, 2014 by Asmita Agrawal

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

2 Answers

+1 vote
Best answer

You can use Export Wizard.

Just right click the database and then , Wizard will open.
Don't select any source let it be default. Click the next and
select destination as Microsoft Excel.

This will solve your problem.

answer Feb 6, 2014 by Atul Mishra
0 votes
  1. Going into database and right clicking on the database and then going to Tasks you will see a option called Export Data, which you will have to click.
  2. After clicking Export Data, a new window will appear where you will have to select the database from where you want the data exported.
  3. After selecting the Data Source you’ll press next and get to a window where you will have to select the Data Destination. You will have a drop-down menu, like the one you can see below where you will have to select Excel as destination type.
  4. The next step would be to browse to the location of where the file will be created and input its name. Also, you should select the version of Excel you want the file to be created for.
  5. Press next and get to the next Wizard window where you have the option of either running a custom query to output custom data from your tables, or just select all data from more tables.
  6. Choose whatever version works best for you, but for now let’s just say you want to export all data from a specific table and thus you’ll choose the first option. The next window you will see will have you select the table or tables you want to select data from. Select the table you want to export data from and either press Next or Edit Mappings.
  7. Press Next to get to the next step of the wizard. You will get to a window where you have the option of running the query “Right Now” and also create an SSIS package.
  8. After you’ve selected the options you’d like, press next. You will get to the last window of this wizard where you will have to press Finish. This will create the export file to the file path you specified with the file name you have selected. If we go to review the file, you can see that the data is in that specific format.
answer Nov 13, 2014 by Manikandan J