I'll be the first to admit, the title for the post isn't the greatest but
didn't know what else to write. Anyways...

Im importing data from Excel into SQL. My StoreNbr coulmn can be in General,
Text, Number, etc... take your pick, the problem still persists.

Sheet1:

StoreNbr

1234
96AB
5678

Only rows 1 and 3 will make it into the DB. Row 2 will show up as a NULL. As
will all other columns with letters in them


Sheet2:

StoreNbr

1234567891
1234
5678

Only rows 2, and 3 will make it into the DB. Row 1 will show up as a NULL.
As will other columns with 10 digits in them.


So, Excel/ SQL/ DTS is determining what my data SHOULD look like, and only
accepting what it feels worthy. Any ideas are appreciated.

--
SQL2K SP3

TIA, ChrisR

The driver is doing it correct

Problem is detailed here

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

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"ChrisR" <bla (AT) noemail (DOT) com> wrote