Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 539
  • Last Modified:

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

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
SAMIR BHOGAYTA
Asked:
SAMIR BHOGAYTA
2 Solutions
 
John ClaesCommented:
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
 
John ClaesCommented:
@samirbhogayta:
can you answer my questions? so I can help you further?
0
 
DhaestCommented:
0
 
Jesse HouwingScrum Trainer | Microsoft MVP | ALM Ranger | ConsultantCommented:
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
 
Mark GeerlingsDatabase AdministratorCommented:
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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now