I'm trying to save a excel file to tab delimited format using a dts script.

However I can open the sheet I can save the sheet as a different name,
but I don't seem to be able to save it as a tab delimited file

Can any one help ?

Thanks in advance

Andrew

Are you after sending the data to a tab delimited file or saving the actual sheet?

ActiveWorkbook.SaveAs Filename:= _
"C:\New Microsoft Excel Worksheet.txt" _
, FileFormat:=xlText, CreateBackup:=False

The problem with the second option is that you will require the Excel dlls on the location from which you execute. If this is to be
scheduled then MS do not recommend running office automation unattended like this



--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"Info" <info (AT) schnof (DOT) co.uk> wrote

Trying save the default sheet to a tab delimited file.

But within a activex script , under the control of dts.

This for a project I'm building at work.

Andrew



Allan Mitchell wrote: