Hi all:
I used DTS to import data from xls file and i choose Microsoft Excel
97 - 2000 as connection, import xls data to server 2003 database.
The problem is that all data from xls would consider as numeric when
i doing transformtions to sql server. so if any letter in xls that would
transfer to sql database be a null.
so what i want to do that is anyone knows how to cast data to varchar
when data are from xls.

Cheers

nick

Might you actually be seeing this?

Excel Inserts Null Values
(http://www.sqldts.com/default.aspx?254)



"Nick" <Nick (AT) discussions (DOT) microsoft.com> wrote