I am having trouble importing data from Excel. The problem
is when I have a column in Excel that contains something
like "1, 1, xcra, and time1" none of the data comes over
in the import. Is there something I can set so that all of
the data comes over regardless of a cells content?

Thanks
DTS Killer

Is all the data for that column of that style?
Do none of the column values come across?
What are you pumping into?
Does the column value actually include the "

I have just tested and it works to import data like yours.

There are issues with Excel and you can see some mentioned here

Troubleshooting
(http://www.sqldts.com/default.aspx?222)



--

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


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