Hi all,

When I try to import an excel file that has a column with
numeric AND text data in it, I get lots of NULLs imported.
Mu column contains values like
"101, 102, 105, 343, 101-34, 304-44, Rosemary, Other text"

sometimes, the numeric values are null and at other times
the text values are imported as NULLs. I have tried making
the format of the column in Excel as "Text". But that
does'nt help either. Is there a way to import the data the
way it and treat it completely as a text column. My
destination (SQL Server table) has the corresponding
column as Varchar(100).

Thanks,
Amir

You are probably encountering this

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

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Amir" <acharania (AT) trimontrea (DOT) com> wrote

This is also documented in:

http://support.microsoft.com/?id=236605

Rand
This posting is provided "as is" with no warranties and confers no rights.