DTS to merge Excel files

From: Cesar Altamirano (cesaralt_at_viabcp.com)
Date: 08/05/04 

Date: Wed, 04 Aug 2004 23:47:30 -0500

Hi,
We have a DTS to create an excel file from a select statement,
all it is ok, until we have to add an elaborated header to each
Excel file created. To create a macro would be very cumbersome
to maintain. then we decided to create an Excel file with only the
header to insert.
How Can we do that in a DTS package?, an ActiveX Script could be
a solution.
Does anybody have some example to do this.
Thanks for any help

Regards,
Cesar Altamirano.

      

Relevant Pages

  • Re: how to create/use temp table on the fly?
    ... I agree with Tom that DTS is the way to go on this one. ... >I still think temp tables are not the route to go. ... >access to an Excel file. ... >data to an excel file on the fly and places each tab ...
    (microsoft.public.sqlserver.programming)
  • Re: DTS to merge Excel files
    ... >> We have a DTS to create an excel file from a select statement, ... until we have to add an elaborated header to each ... >> How Can we do that in a DTS package?, ... >> Cesar Altamirano. ...
    (microsoft.public.sqlserver.programming)
  • Re: Importing and exporting between VB.NET and SQL Server 2000
    ... DTS can do this sure. ... So VB.Net will export attributes from a SQL Server entity to an XL ... > of doing is to make a stored procedure to import the Excel ... > proper syntax in importing the Excel file in SQL Server? ...
    (microsoft.public.sqlserver.dts)
  • Re: Using DTS to export to Excel
    ... If no Excel File exists DTS will not automagically create one ala csv files. ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > I have written VB code to create a DTS package. ...
    (microsoft.public.sqlserver.server)
  • Re: Using DTS to export to Excel
    ... If no Excel File exists DTS will not automagically create one ala csv files. ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > I have written VB code to create a DTS package. ...
    (microsoft.public.sqlserver.tools)