The data in the source column is too large for the specified buffer size.

Source: Internet
Author: User
Tags sql using
When importing data from Excel to SQL Server, the following problems may occur:
The data in the source column is too large for the specified buffer size.

The solution is as follows:

SQL Server determines the data type and length from the first few rows of data in an Excel table. Therefore, the data in the first few rows is written shorter, so the data will not be imported in the future.

========================================================== =

Hi,

I have a problem of importing Excel data into the SQL database. when I import the database (finish all importing steps ), it tell me "fail to copy 1 Table" and I go to view the error message say that "error at source for row number 19. errors encountered so fat in the task: 1. data for source column 2 ('note') is too large for the specified buffer size."

I try to remove that line record but still have into lines have the same problem. So, can I change the importing buffer size in SQL Server to make me import data becomes successful ??

Thanks a lot.
----------------------------------------------------------------
You're probably loading it to a pre-made table right? I'm assuming you have a varchar field That isn' t large enough. try maxing it out to 8000 to make sure. it's kind of a pain to load in batch. it always makes me nervous
----------------------------------------------------------------
Thanks for reply. I try it but I got the same error message. Is it need to set more bigger buffer size for SQL Server importing the data?
---------------------------------------------------------------- Oh... I got it.
Because the SQL will specify the buffer size on that column field of the first eight rows. So, I moved the field which have character to the second row. Then it works.
Thanks for help

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

Hello there,

I have and small Excel file, which when I try to import into SQL
Server will give an error "data for source column 4 is too large
The specified buffer size"

I have four columns in the Excel file, one of the column contains
Large chunk of data so I created a table in SQL Server and changed
Type of the field to text so I cocould accomodate this field but still
No luck.

Any suggestions as to how to go about this.

Thanks in advance,
Srikanth Pai

----------------------------------------------------------------
How are you importing? BCP, DTS or what?
We are currently using bcp to import text fields without any problems.
I have used also used DTS for importing text fields in the past.

----------------------------------------------------------------
Hello there,

I am using DTS to import the Excel file...

Thanks,
Srikanth Pai

----------------------------------------------------------------
Pai,

Some suggestions for you.

(1) Try using BCP.
(2) try with a manually created file and see if you can work out
Differences between your sample file and the prblem file. It maybe
Some data, eg quotes or control chars that are
(3) Send Me email containing your schema and a sample data file
(Cutdown to the 2meg Hotmail limit) and I'll have a look.
----------------------------------------------------------------
Thanks promised one for everything, what I did here was saved
Excel file as a. txt file and then imported the file sucessfully, I
Have never tried BCP?

----------------------------------------------------------------
FYI all, I had problems exporting to SQL from access. so by exporting
to text (from access) and then to SQL using DTS... it worked!
================================================= ======

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.