Senator Guerra Souty original series calendar,replica hublot blue steel peach pointer collocation of rolex replica Rome digital scale, track type minute replica watches scale shows that the classical model is swiss replica watches incomparable, wearing elegant dress highlights.
mr-ponna.com

 

YOU ARE HERE: HOME Questions How to retrieve data from SQL Server multiple tables to Excel multiple sheets



Export SQL Server tables to Excel sheets

View(s): 15120

How to retrieve data from SQL Server multiple tables to Excel multiple sheets

Answer 1)

We have lot of solutions to achieve above functionality. But I’m listing easy and best solutions here:
  1. If you are using SQL Server 2005 or above, using SSIS you can export tables to excel sheets
  2. if you are using earlier version of SQL Server, same thing is achieved using DTS packages.
  3. If you want to do from .NET, fill your DataSet with required tables and save the DataSet to expected office XML format. Following article describes how to Export DataSet to Multiple Excel Sheets. (This solution works for Excel 2003 and later versions)
Note: we can use office automation (VBA), but Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, ASP.NET, DCOM, and NT Services), because Office may exhibit unstable behavior and/or deadlock when Office is run in this environment.

  Asked in:  SemanticSpace Technologies   Expertise Level:  Intermediate
  Last updated on Thursday, 21 June 2012
4/5 stars (7 vote(s))

Register Login Ask Us Write to Us Help