Hi everybody,
I need to Import an Excel sheet from a directory into a table in SQL using DTS. But before putting the excel file in the directory, I need to open that excel file and remove the first row of excelsheet. Is there anyway that I can do it in DTS?
Thanks

Are you talking about the column headers or the first data line?

Rand

The row that needs to be removed is the first data line in the excel file.
Any Idea?

You can set up the DTS to skip rows. In the DTS Designer, open the properties dialog for the import, then go to the Options tab and you'll find a field named 'First Row' which you can change as you like.

Hi Again,
Sorry but I did not get your idea. Could you pls give me some details. I get an excel file from email everyday. then I import it into a SQL server using DTS.
Here is the example. I need to remove their header of the report which is " Report solution" located at the first row fot the worksheet.
Thanks

                   Report Solutions
Name Last name Prop Address Prop City Prop State Prop Zip
Adam Sanler 100 Jane Street New York NY 10254

I have a problem like yours as follows"
I will remove last row,How can I do?

hiroki wu