"Ravi" <rravi3@Covansys.com> wrote in message
news:091a01c3622c$982fac10$a601280a@phx.gbl...
> 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

<rravi3@Covansys.com> wrote in message
news:027f01c36232$611ad0a0$a001280a@phx.gbl...
> 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
>
> >-----Original Message-----
> >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@Covansys.com> wrote in message
> >news:091a01c3622c$982fac10$a601280a@phx.gbl...
> >> 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
> >
> >
> >.
> >