Results 1 to 7 of 7
  1. #1
    Join Date
    Apr 2006
    Posts
    9

    Unanswered: Too large for the specified buffer size

    Hi

    I've been searching this site and the Web for info on an error message I get when importing from Access 2003 into SQL Server 2000.

    'Data for Source Column 3('Col3') is too large for the specified buffer size'

    A memo field in Access is larger than 255.

    I have followed advice about putting the field to the first column. This doesn't work - the error just returns the new column number. In fact, I've tried just importing the first column - no good.

    I am wary about making Registry changes as comments on the Web say this doesn't work either.

    Does anybody have the solution for this.

    Paul

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Col3 is a memo field in Access? What is the datatype of the column you are importing to?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Apr 2006
    Posts
    9
    Hi

    Thanks for replying. Its a text field.

    Paul

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    What tool are you using to import the data? DTS? MS Access?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  5. #5
    Join Date
    Apr 2006
    Posts
    9
    I'm running a Job in DTS SQL Server 2000. I'm linking to the Access database, and entering the data into an SQL table - at least I'm trying.

    Thanks

  6. #6
    Join Date
    Feb 2008
    Posts
    1

    Talking hope this helps

    had this problem for a while and tried everything. In the end I changed the dts package to convert the varchar to a ntext, import data and then change field back again at the end.

  7. #7
    Join Date
    Apr 2006
    Posts
    9
    Hi Micalo

    This is a long time ago now, but I thing that I did something similar to what you suggest.

    Thanks for taking the trouble to reply.

    Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •