Hi

I need to import data from Excel 2003 to SQl Server

I could see that the first row is always treated as the column headers and the data from the second row is assumed to be the real data

Actually in my Excel File, we have some author and File information in the first two lines
The column headers and the data start from Line 3

Is there any way to let the DTS package consider the 3rd row as column headers and data from 4th row

Any help on this would be much appreciated

Cheers
Sanka

Have a look at the "First Row" property on the last tab of the datapump.
Also, because the Excel driver will get confused with datatypes, in the
Extended Properties of your Excel connection set IMEX=1

Have a look here

Excel Inserts Null Values
(http://www.sqldts.com/default.aspx?254)

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Sanka" <loonysan (AT) mailcity (DOT) com> wrote

If you set a named range in Excel for the data you want to import, when you
design your DTS package the range name should be shown as a source
worksheet to import.

Rand
This posting is provided "as is" with no warranties and confers no rights.