I am trying to import some data from excel to SQL server table. In excel
file there is a column which is mostly empty [around 99 % rows] so when I
am importing the file. the DTS package is putting null in all rows even if
there is a value in that row for that column. is there any bug in it? do I
need to change some setting ?

Please let me know.

thanks,
H.

--
Message posted via http://www.sqlmonster.com

This is a flaw in the Excel ISAM driver. It only searches the first 8 rows
to determine the data type of each column in the Excel sheet. If it only
finds empty cells it assigns some undefined datatype to it.

Workaround: Just enter some dummy value into the first row of the column and
everything will work fine.

HTH,
Axel Dahmen
www.sportbootcharter.com




-------------------------
"point99 via SQLMonster.com" <forum (AT) SQLMonster (DOT) com> schrieb im Newsbeitrag
news:9f3ae51a2ad046cfac4c2ab01efb5b3e (AT) SQLMonster (DOT) com...

I just spent over 3 hours resolving this same issue with the same
conclusion!! Where can I find the detailed informationabout the Excel ISAM
driver?

"Axel Dahmen" wrote:

Can't tell. Found the solution myself by try-and-error. And someone in some
discussion forum shared the same thoughts later.

Regards,
Axel Dahmen


--------------
"TACIR" <TACIR (AT) discussions (DOT) microsoft.com> schrieb im Newsbeitrag
news:B82825E0-731A-448D-990E-1F67564071AD (AT) microsoft (DOT) com...

We have a couple of articles here and one that details the old NULL
problem.

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


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




"Axel Dahmen" <NO_SPAM (AT) NoOneKnows (DOT) invalid> wrote