Export dynamic view

[Kalin]

Hi,

in a db I have I have a view which is a pivottable made from a table in this db. I need to export this data to Excel on a regular basis, so I want to create a DTS package to refresh the view (drop and recreate) and then export it to Excel.

Since the view is a pivot of one of the tables the columns can vary both in amount and name, the values in the columns are always integers.

What is the best way to extend the excel-sheet to incorporate all columns in the view ??

And how is this done ??

Grtz,

Kalin

 

[DrSql]

Paste your view that you created, also its not a best practice to use Excel. CSV or text is better.


Dr.Sql
Good Luck.