sql server dts: Import From Excel -- sql server dts

Import From Excel

Travis Tan
9/6/2004 7:55:22 PM

sql server dts:

Hi ,

I am using the DTS to import the excel file to SQL
Server.
This excel files is generated by other system and is
already in fix format, my job is only import the data to
SQL Server.But , I found out that the excel file did not
have any column header in row 1.
That means the data start from row 1.But in DTS , it
recognize the row 1 as heading and I am unable to import
the row 1 record.
Anyway to solve this up.Please help.

Re: Import From Excel

Allan Mitchell
9/7/2004 6:08:18 AM

This will help

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

[quoted text, click to view]