Urgent - sql server data type

[olibh]

I need to store a text file into a sql server field - I am cureently using varchar however the data is getting truncated as it is more than likely greater than 8000 characters.

I may need to hold up to 20,000 characters
I tried to use text which I believe can hold up to 2GB of data but
when I look in the field nothing has been imported - can anyone help

 

[SQLSister]

YOu need to handle data differntly when in a text field, look up writetext command in books online.