Importing from Access Error

• David Burrows

  SSC Guru

  Points: 65144

  More actions

  September 23, 2003 at 3:04 am

  #475359

  Access Memo field equates to SQL text field and allows for text greater than 255 for Access and 8000 for SQL. If you try to DTS a memo column that has text longer than the destination (7000 in your case) then you get this error.

  Far away is close at hand in the images of elsewhere.
  Anon.

• StefanJ

  SSCarpal Tunnel

  Points: 4713

  More actions

  September 23, 2003 at 4:38 am

  #475371

  I thought a solution might be to use left(remarks,7000) on the source field but this made no difference. I thought I might then try to trim trailing white space in the transformation. This actually worked without the left function removing the traling 1500 characters over 7000! Not sure why this worked?