Help for write a excel document from sql

Question

Help for write a excel document from sql

Oscar Quintanilla

Grasshopper

Points: 16
More actions
April 9, 2007 at 9:49 pm

#153516

Dear Friends
I write data into an Excel Worksheet from a dts package and it works fine for the first time but in the second it appends the new data to the first and I don't want it that way, and if i delete the first worksheet, in the second time gives me an error reporting there is no excel worksheet to write.

Thanks in Advance

Oscar Quintanilla

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

David Scotland-132255 SSCertifiable Points: 5599 More actions · Answer 1

I have always just dropped the table in the worksheet as the first step in the package and recreated it in the second and the after the do what you have to export the data into the sheet.

hth

David.

Steve Jones - SSC Editor SSC Guru Points: 738609 More actions · Answer 2

The worksheet name is the table name, so if you name your worksheet and then create the table to match, it works fine. I've also done the "drop table" as the first step and then the create table to get Excel to properly display data.

Oscar Quintanilla Grasshopper Points: 16 More actions · Answer 3

Thanks for your answer but I really don't know where to 'Drop the table', I have created the table from the DTS and at that place i can't find where to Drop - Create table, please tell mehow to do it

TIA

Oscar Quintanilla