Hi,
I'm trying to import an excell file into a file. I cannot get the first
line. DTS considers the first line as the name of the columns.
I am using a transform data task and even when I put the value 1 in the
option "first row" he stil starts importing with second row.

Has anyone got a solution?
Thanks

Yep

Excel treats First Row of Data as Headers
(http://www.sqldts.com/default.aspx?255)

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"mehdi" <mehdi (AT) discussions (DOT) microsoft.com> wrote