Hi all,

Thanks for your help in advance.

The problem that we are having is that when we try to
transform text data from Excel to a varchar in SQL Server
numeric values are transformed as Null values. For
example if the Excel dataset is like below the numeric
values are copied as Null values:

Id Value
1 TestValue1
2 TestValue2
3 3
4 4
5 TestValue5

So for example the data that is copied to SQL Server ends
up as:

Id Value
1 TestValue1
2 TestValue2
3 NULL
4 NULL
5 TestValue5

The Id column is text as well and all the numeric values
are transformed with no problem.

Again, thanks for your help,

Michael

The answer is contained in this article

Excel Inserts Null Values
http://www.sqldts.com/default.aspx?6,222,254,0,1

--


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

"Michael McMurtrey" <mmcmurtrey (AT) hotmail (DOT) com> wrote