Some records in a column imported as null

2 Sep 2006 11:58 AM

itsyash

Hi,

I am trying to use the import export wizard to transfer data from Excel
to SQL Server 2000.

The challenge:

I have a column which has numbers that are manually entered. Some
numbers have "/" between them. There are also a few email addresses in
the column but I cannot change that. When i import the data into SQL
all email addresses and numbers that contain "/" are eliminated. Those
fields show up as NULL.

I tried changing the datatype of the column to nvarchar and varchar
with 255 characters before importing the data. Even then this doesnt
work.

A few people told me that this used to work previously but does not any
more. Some one please help me.

Thanks,
Yash

3 Sep 2006 5:51 PM

Bobby Henningsen

Hi there Yash,
are you using DTS ? Then have a look at this :
http://www.sqldts.com/default.aspx?254

Regards :)
Bobby Henningsen
<itsy***@gmail.com> wrote in message
Show quote

news:1157198293.623946.262260@74g2000cwt.googlegroups.com...
> Hi,
>
> I am trying to use the import export wizard to transfer data from Excel
> to SQL Server 2000.
>
> The challenge:
>
> I have a column which has numbers that are manually entered. Some
> numbers have "/" between them. There are also a few email addresses in
> the column but I cannot change that. When i import the data into SQL
> all email addresses and numbers that contain "/" are eliminated. Those
> fields show up as NULL.
>
> I tried changing the datatype of the column to nvarchar and varchar
> with 255 characters before importing the data. Even then this doesnt
> work.
>
> A few people told me that this used to work previously but does not any
> more. Some one please help me.
>
> Thanks,
> Yash
>

--------------------------------------------------------------------------------
Jeg beskyttes af den gratis SPAMfighter til privatbrugere.
Den har indtil videre sparet mig for at få 509 spam-mails
Betalende brugere får ikke denne besked i deres e-mails.
Hent en gratis SPAMfighter her.