I have a similar situation. I must migrate data from MS Access 2010 to SQL Server 2008.

The Access table contains a field with the Attachments data type.

This field type allows you to store multiple documents (PDFs) for a single record in a single cell.

The software we are migrating to uses SQL Server 2008 as the back end database.

The vendor suggests just creating a separate field for each attachment.

That is not a good solution for us.

Is there a field type in SQL Server 2008 that works like the Attachments field in Access 2010? I will manually add the attachments to the records, but would like to have the ability to add future attachments to existing records.

Any thoughts on how to proceed?

e