Solved

How can I export the whole database from sql server to excel sheet

Posted on 2011-02-18
8
530 Views
Last Modified: 2012-05-11
Hello,

How can I export the whole database from sql server to excel sheet on a one click button event, or with only one option in menu like, "Export To Excel"
0
Comment
Question by:SAMIR BHOGAYTA
8 Comments
 
LVL 10

Accepted Solution

by:
John Claes earned 250 total points
ID: 34924629
1) You know that Excel can't support more then X Number of records / Sheet ==> table
2) You know that Excel can't support more then X unmber of Sheets ==> Tables

Is there a special reason why you want everything exported to a Excel file ? and not a CSV or something?

I ask this question because of the boundries set by Excel ....

regards
poor beggar

0
 
LVL 10

Expert Comment

by:John Claes
ID: 34941001
@samirbhogayta:
can you answer my questions? so I can help you further?
0
 
LVL 53

Assisted Solution

by:Dhaest
Dhaest earned 250 total points
ID: 35293993
0
 
LVL 17

Expert Comment

by:Jesse Houwing
ID: 35294132
You can query the content of a database table from inside Excel using the data tools, but Excel isn't the ideal tool to use for exporting your data. You could try Access, which is a far better match, but even Access has its limitations.

What are you trying to accomplish here? Maybe we can help you on a more architectural/design level first, before trying to solve a problem with the wrong tool for the job.
0
 
LVL 35

Expert Comment

by:Mark Geerlings
ID: 35295781
A "whole database"  in SQL Server usually contains multiple tables, and these usually have very different column configurations.  How do you expect a single Excel spreadsheet to accomodate this variety of columns?  Then there is also the issue of the number of records per sheet that Excel can support (ike poor-begger already mentioned) and this limit is *FAR* less than what a SQL Server table could hold.

Extracting data from a single SQL Server table to an Excel spreadsheet may be a realistic task *IF* the table does not have too many rows, or if you limit the number of rows to what Excel can handle.
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now