Importing data with leading 0

I am trying to import some data from excel into SQL Server table - some of
the data has a leading 0 ie 0897 - when I import it, it imports these record
s
as NULLS. How do I import the record so it is 897.
Thanks in advanceHow are you importing the data?
AMB
"ChrisB" wrote:

> I am trying to import some data from excel into SQL Server table - some of
> the data has a leading 0 ie 0897 - when I import it, it imports these reco
rds
> as NULLS. How do I import the record so it is 897.
> Thanks in advance|||Using DTS
"Alejandro Mesa" wrote:
> How are you importing the data?
>
> AMB
> "ChrisB" wrote:
>|||Have a look at;
http://support.microsoft.com/defaul...-US;Q194124#kb3