Re: DTS to merge Excel files

From: Uri Dimant (urid_at_iscar.co.il)
Date: 08/05/04 

Date: Thu, 5 Aug 2004 08:36:02 +0200

Cesar
If you specify COPU COLUMN is it still does not work?

"Cesar Altamirano" <cesaralt@viabcp.com> wrote in message
news:ef73h0dn7ckuutqeht5drbtqr7qk02u5kb@4ax.com...
> 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)
Loading