DTS export to Excel

[Paulw88]

I need to learn how to set up a DTS package to export data to an Excel format, overwriting or deleting the existing Excel file. Can anyone help me? TIA

Paul

[techguru]

it's very simple in SQl Server ...

here are the steps ...

Start the DTS Import/Export Wizard, and then select a data source on the Choose a Data Source tab. After you select a data source, the focus changes to the Choose a Destination tab.

In the Destination list, click Microsoft Excel 97-2000 or any version you have on your PC as the destination database type. Use this same type for Microsoft Excel

In the File name box, browse to an existing Excel workbook file. This file must not be open in Excel while you are completing the wizard. If you have Excel installed on your computer, you can create a new Excel file at this point without leaving the wizard. To do so, right-click the Select file text, point to New, and then click Microsoft Excel Worksheet.

Hope this answers your questions....