I'm importing an excel file with the dts wizard and running into these weird results
1. Whole number columns still go in as float not int, but when I change in transformation get an error
2. columns formatted to 2 decimal places go in with a lot more than 2
3. Text columns that have numbers or dates accept some while others are set to null

I have set Jet to check first 8 rows to determine datatypes, and mixed types to be set to text. What else can I do to get some kind of consistency
Any help on this would be greatly appreciated

No doubt Excel's formatting is getting you here

You do not want Excel to only check the first 8 rows (default) Have a look
here

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




--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


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

consistency?