Click here to Skip to main content
11,789,512 members (38,200 online)
Click here to Skip to main content

Tagged as

How to Copy SQL Table Into Excel and Other Formats

, 10 Jul 2013 CPOL 11.2K 5
Rate this:
Please Sign up or sign in to vote.
How to copy SQL table into Excel and other formats


This post shows you how to take SQL table into Excel and other formats.

  1. Open ssms2012->databases->sample database.

  2. Click that export data. There is a new window open as shown below:.

  3. Choose the datasource, there are a lot of datasources dropdowns here:

  4. Choose the source database, here  dbo.sample is a source database.

  5. Here, you choose designation Database or other formats like oldb, excel formats.

  6. Then Excel file path.

  7. Select the first radio button for copy or second radio button for query to write the data, choose any one.

  8. Click next->select table you want to copy:

  9. If you want edit the columns means you have to use this window editmapping.

  10. You can check the preview for here:

  11. Click next.

  12. Finish.

  13. After you click finish, you can see files can be transferred like below:

  14. Go to->myDocuments, open the Excel file that you already created and all data comes to Excel sheet. That’s all.


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


About the Author

India India
Production & Application DBA ,Asst Programmer

You may also be interested in...

Comments and Discussions

QuestionHow can i Export SQL Server 2005 tables? Pin
Uganraj11-Jul-13 20:53
groupUganraj11-Jul-13 20:53 
AnswerRe: How can i Export SQL Server 2005 tables? Pin
apachearun11-Jul-13 21:20
professionalapachearun11-Jul-13 21:20 
GeneralMy vote of 1 Pin
H. Mueller10-Jul-13 20:34
professionalH. Mueller10-Jul-13 20:34 
GeneralRe: My vote of 1 Pin
apachearun10-Jul-13 21:01
professionalapachearun10-Jul-13 21:01 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Terms of Use | Mobile
Web01 | 2.8.1509028.1 | Last Updated 11 Jul 2013
Article Copyright 2013 by apachearun
Everything else Copyright © CodeProject, 1999-2015
Layout: fixed | fluid