I read an Excel file which has a char column header, then an empty row and
then numeric entries. Doing this, I get the Char column header as my column
name in SQL Server, but I can never get the char column header as an entry in
my database, even not when inserting a row above it. Any ideas ?

This is the Excel

AB CM HC MB

1003 1006 1004 1001
1005 1012 1008 1002

And what happens? They come in as NULLs ?

Does this help?

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.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


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