The VARCHAR() datatype can be up to 8000 characters long. If you need more than that, you have my condolences and you need to resort to a TEXT column instead.
I'm not sure why your data is only importing 352 characters. 255 is a common problem, where people don't reset the maximum column width supported by Query Analyzer from the default value. I don't think I've ever seen 352 as a limit.