Transfer file image datatype from SQL Server to Access OLE Object datatype

[noecantim]

Hi,

I´ve created a DTS with Visual Studio .Net (SSIS) for transfer data from a SQL Server database to an Access Database. It is not necessary to know SSIS to you be able to help me since I can write Visual Basic Scripts.
The problem is a field corresponding to files that are saved in SQL field as image datatype.
All files fields show <Binary data> as the content of the field, they are saved as array of bytes.
When I tranfer this data into a new field in an Access database they are converted to OLE Objects datatypes as I want. The problem is the files are not saved as embbeded objects that I am able to open with double click as I do with the files I move directly to this OLE object field. The content that is saved is "binary data".

Any idea about to do this operation?I accept new ways to do this result.

Thanks!!

[FishVal]

@noecantim
Is content of the field in embedded OLE format or is it a neat file?

[noecantim]

The content of the field is binary data but I would like to get embedded OLE format in the field.

[FishVal]

To tell the truth, maybe the only viable solution is to let Access embedded OLE form control to save file to table field.

Also, you should take into account that embedded OLE format takes much more disk space to store which could be a problem since db file size may quite easily get to 2G limit with only several hundreds or thousands records.

Also, you may read this article about handling picture files as BLOBs in Access database.

Regards,
Fish.