Data conversion from xls

I have an xls with a column containing EAN codes - 13 digits. The problem
described below occurs regardless of xls column format - I've tried text,
number, exponential.

I need to get this into an SQLS DB, but any import routine I've tried so far
only yields NULL for any data in the xls column (many rows are empty). I've
tried various datatypes for the field (bigint, nvarchar) but same result
regardless.

Trying to do a straight transformation task copy column, I get an error
"general conversion failure on column pair (source column [...] (DBTYPE_WSTR),
destination column [...] (DBTYPE_I8). I tried to write an ActiveX transform,
but no luck with that either.

Anyone know of a way to get around this?

Thank you.
knutb
oslo

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-msde/200605/1
.

Loading