Click here to Skip to main content
Click here to Skip to main content

Tagged as

How to Copy SQL Table Into Excel and Other Formats

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

Introduction

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.

License

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

Share

About the Author

apachearun
Database Developer NEELKANTH DIGITAL INFONET
India India
Production & Application DBA ,Asst Programmer

Comments and Discussions

 
QuestionHow can i Export SQL Server 2005 tables? PingroupUganraj11-Jul-13 21:53 
AnswerRe: How can i Export SQL Server 2005 tables? Pinprofessionalapachearun11-Jul-13 22:20 
QuestionMessage Removed PinmemberArash M. Dehghani11-Jul-13 0:39 
AnswerMessage Removed Pinprofessionalapachearun11-Jul-13 1:10 
GeneralMessage Removed PinmemberArash M. Dehghani11-Jul-13 1:28 
GeneralMessage Removed Pinprofessionalapachearun11-Jul-13 1:40 
GeneralMy vote of 1 PinprofessionalH. Mueller10-Jul-13 21:34 
GeneralRe: My vote of 1 Pinprofessionalapachearun10-Jul-13 22: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.150414.1 | Last Updated 11 Jul 2013
Article Copyright 2013 by apachearun
Everything else Copyright © CodeProject, 1999-2015
Layout: fixed | fluid