469,333 Members | 4,367 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,333 developers. It's quick & easy.

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

Hi,

Ive 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!!
Oct 14 '09 #1

✓ answered by 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.

3 5048
FishVal
2,653 Expert 2GB
@noecantim
Is content of the field in embedded OLE format or is it a neat file?
Oct 15 '09 #2
The content of the field is binary data but I would like to get embedded OLE format in the field.
Oct 15 '09 #3
FishVal
2,653 Expert 2GB
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.
Oct 15 '09 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by Kevin Vogler | last post: by
2 posts views Thread by Robert | last post: by
11 posts views Thread by Abhishek | last post: by
7 posts views Thread by Gary Shell | last post: by
5 posts views Thread by Mark | last post: by
2 posts views Thread by Bonzol | last post: by
3 posts views Thread by =?Utf-8?B?ZGF2aWQ=?= | last post: by
7 posts views Thread by shadowman | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by haryvincent176 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.