DTS import from excel cell with more than 256 characters

Hi,

I am trying to import a file from Excel to SQL using DTS. I have determined that the problems I am getting are because one of the columns in Excel has cells containing more than 256 characters. I have reformatted the data in Excel to text in an attempt to ensure that the whole is imported. When I attempt it as is, I get an error "Data Source Column 7 is too large for the specified buffer size". By reducing the data to less than 256, I can import but of course the data is incomplete.Where can I increase the buffer size? I am aware that fetch data and put data buffers refer to rows not data.- or is there a better way of doing this?
I am using SQL 2000.
Please help me in achiving above task.
Thanks & Regards,
Nishant Shende

Check the following article...
http://support.microsoft.com/default.aspx?scid=kb;en-us;281517

Hi,
Thanks for replay,
But any column can exceed 255 character length.
Now I am getting above mentioned error in 57nth column
I have tested this by setting TypeGuessRows to 0 and also 500 but no success.
Isn't Microsoft given concrete solution on this issue?
Thanx
Nishant...