Hi,

When I import from excel the first few columns decide the
data type. I my first few cokumns are text followed by
numeric. The value are stored as null in the Sql db after
importing. This is know problem in Sql, is there any way I
can bypass this programatically.

Regards
Sats

This will 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.konesans.com - Consultancy from the people who know


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