Convert Access Attachment datatype to SQL Server 2005

• Loner

  SSC-Insane

  Points: 21279

  More actions

  April 9, 2010 at 7:46 am

  #217723

  I tried to convert an access database with one column of attachment datatype to SQL server.

  I used the SSMA tool from Microsoft to migrate the database but the attachment datatype became ntext datatype and had only the gif file name in that column instead of the real image.

  How can I convert the image of the attachment datatype to SQL Server with the image data type?

  Thanks

• krclarke

  SSC Veteran

  Points: 269

  More actions

  October 4, 2011 at 8:02 am

  #1390153

  Hey,

  Did you ever find a solution for this?

  Thanks

  Kevin

• Jo Pattyn

  SSC-Dedicated

  Points: 32348

  More actions

  October 5, 2011 at 3:22 am

  #1390552

  Seems it is a multivalued field relating to more records. Have a look at

  http://blogs.office.com/b/microsoft-access/archive/2007/08/24/adding-removing-and-saving-files-from-the-new-attachment-field-in-access-2007.aspx

  where they mention add/saving/removing attachments in vba.