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

Posted on 2005-03-18
Medium Priority
Last Modified: 2011-08-18
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?
Question by:rseraji
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
LVL 51

Expert Comment

by:Ted Bouskill
ID: 13579454
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?

Author Comment

ID: 13579721
Yes I tried varchar(8000).
LVL 51

Accepted Solution

Ted Bouskill earned 2000 total points
ID: 13580193
Here you go, I think this is the issue:


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.

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently I was talking with Tim Sharp, one of my colleagues from our Technical Account Manager team about MongoDB’s scalability. While doing some quick training with some of the Percona team, Tim brought something to my attention...
In today's business world, data is more important than ever for informing marketing campaigns. Accessing and using data, however, may not come naturally to some creative marketing professionals. Here are four tips for adapting to wield data for insi…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

801 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question