I'm trying to import a column of mixed data from Excel to
SQL Server. This column contains some numeric values and
some alphanumeric. I was getting null values for the
alphanumeric values until I used disconnected edit to
change the Extended Properties string to include the
IMEX=1 parameter. Now all the data imports but the
numeric values are importing in scientific notation. Is
there a work around to fix this? Thanks.

Sondra

What is the datatype of the destination?


--
--

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


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