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
