When importing Excel data into a SQL Server table,
sometime DTS/Enterprise Manager tries to read one more
empty row. This causes an 'not Null allowed' error for
the PK column.

Also, sometimes when previewing the source data, data in
some cells were missing. This also caused an "not Null
allowed" error.

How can I prevent these errors? How do I prepare a
perfect Excel data file for importing Excel data into SQL
Server?

Thanks In Advance.

Jeffrey

The reason DTS tries to import a last row is because there is a row but
there just isn't data therein. You can Delete this row from the Excel file.

For Nulls do you mean this

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


"Jeffrey" <jwang (AT) dot (DOT) state.tx.us> wrote