Data Format issue while importing data from Excel to SQL

hi

when i m importing data from excel to Sql using DTS the column which has text content was not imported as same in excel sheet. whereas a special character is appearing in between the lines. the text field contains multiple lines but the conetent is imported in single line .

ex:

ARIZONA
ALABAMA
STATE

but i m getting imported

as :

ARIZONA ALABAMA STATE

How to Format a single column while importing?

Regards

Raj

That is a very special and custom task which has to be coded on your own, there are no built in functionalities for this nested entities.

Jens K. Suessmeyer.

http://www.sqlserver2005.de