• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 7628
  • Last Modified:

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

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?
0
rseraji
Asked:
rseraji
  • 2
1 Solution
 
Ted BouskillSenior Software DeveloperCommented:
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?
0
 
rserajiAuthor Commented:
Yes I tried varchar(8000).
0
 
Ted BouskillSenior Software DeveloperCommented:
Here you go, I think this is the issue:

http://support.microsoft.com/kb/281517/EN-US/

Apparently, the Jet driver guesses at the maximum row size based on the first 8 rows!  If any rows past the first 8 are larger, the process fails.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now