Hi,
I am facing a strange Problem
The First row and second row of my excel are alpha numeric
and the rest are numeric, yet when I dump the data in a
text file its showing the data as null why? where as the
numeric data is being ported correctly why?
Thanks
Ravi

Here you go

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



"Ravi" <rravi3 (AT) Covansys (DOT) com> wrote

Yes , This I got you sent me this before I argument is
arent the first 2 rows enough for excel to decide that its
alpha numeric data
To test the corollary I keyed in the first 6 rows as alpa
numeric and LO!!! It takes in alpa numeric data but
ditches numeri data

No 2 rows is not enough for the driver

the default is 8

--

----------------------------
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



<rravi3 (AT) Covansys (DOT) com> wrote