<div>
Have you tried changing the text column to varchar(8000)? &nbsp;Otherwise can you give me an example of the data you are trying to transmit?
</div>


Have you tried changing the text column to varchar(8000)?  Otherwise can you give me an example of the data you are trying to transmit?

<div>
Yes I tried varchar(8000). 
</div>


<div>
<div class="content wysiwyg-content">
I see other folks have had this issue as well but I tried the suggestions and still the problem continues. Trying to import using DTS from Excel into SQL2K sp3a. I get the above message though. I have tried making the column in SQL a Text data type. I have also made sure they aren't reserved SQL Server keywords. I also tried to import from the Excel file into a .txt file and had the same issue.<br />
<br />
Any ideas?
</div>
</div>


I see other folks have had this issue as well but I tried the suggestions and still the problem continues. Trying to import using DTS from Excel into SQL2K sp3a. I get the above message though. I have tried making the column in SQL a Text data type. I have also made sure they aren't reserved SQL Server keywords. I also tried to import from the Excel file into a .txt file and had the same issue.

Any ideas?

Data for source column... is too large for specified buffer size.

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.