sql server dts: SQL table only accepts 1 Excel data format -- sql server dts

SQL table only accepts 1 Excel data format

ChrisR
1/28/2005 4:15:14 PM

sql server dts:

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

Re: SQL table only accepts 1 Excel data format

Allan Mitchell
1/29/2005 6:50:19 AM

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

[quoted text, click to view]