使用SSIS将数据从SQL Server导出到Excel [英] Export data from sql server to excel using SSIS

问题描述

大家好，

首先，我将解释我的要求，然后再解释到目前为止我所做的事情以及我需要的全部帮助...

我必须将数据从SQL Server导出到Excel工作表. Excel工作表将类似于标准模板.如果我运行项目，则应将来自SQL Server的数据插入一个新的Excel文件中，该文件应使用该模板，并且应将其创建并保存到新位置.同样，通常我们将第一行用作标题.但根据我的要求，模板将具有两行或三行标题.因此，应该从第三行/第四行自动插入数据.

我已经完成了将数据从sql server数据库导出到普通的Excel表的工作，其中第一行作为标题.我还完成了将数据从不同表导出到同一excel文件的不同工作表的操作.

任何机构都请提供模板格式的帮助，在运行项目时创建新的excel文件，并以两行或三行作为标题.

我正在使用SQL Server 2005和Visual Studio2005.

请帮忙...提前感谢...

Hello All,

First I will explain what is my requirement and then I will explain what I have done so far and what are all the helps I need...

I have to export data from sql server to excel sheet. The excel sheet will be like a standard template. If I run my project, the data from SQL Server should be inserted into a new excel file which should use that template and it should be created and saved into a new location. Also, generally we will use first row as header. But in my requirement, the template will have two or three rows header. So, the data should be inserted automatically from the third/fourth empty row.

I have done exporting data from sql server database to normal excel sheet with first row as header. I have also done exporting data from different tables into different sheets of the same excel file.

Any body please help out for the template format, creation of new excel file while running project and two or three rows as header.

I am using SQL Server 2005 and Visual Studio 2005.

Please help out...Thanks in advance...

推荐答案

请从这里开始:
SSIS包:每天从数据库导出数据到新Excel不使用脚本任务 [使用SSIS 2005动态创建Excel文件，ExcelSheets并从SQL Server导出数据 [ ^ ]
使用SSIS加载动态Excel文件 [将数据导出到Excel [使用VB.Net导出到Excel [无需从数据库自动将数据导出到Excel，Word，PDF [ ^ ]

Please, start here:
SSIS Package: Export Data from Database, Daily to New Excel Without Using Script Task[^]
Dynamically creating Excel File, ExcelSheets and Exporting Data from SQL Server using SSIS 2005[^]
Dynamic Excel file loading with SSIS[^]

and similar...
Exporting Data to Excel[^]
Export to Excel using VB.Net[^]
Export Data to Excel, Word, PDF without Automation from DataBase[^]

这篇关于使用SSIS将数据从SQL Server导出到Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！