Access database - extracting jpg data into jpg file

[ryk]

Hello,

I am using LabWindows/CVI 2010, MS Access 2010, and using a database that contains image data (jpg, tiff, cad) along with other data types that I can read using the binding function within CVI (eg, DBBindColInt, DBBindColChar etc).  

Viewing the image data as it is stored in this database, the .jpg files are shown as long binary data while in normal view and as OLE object in design view (see attached screen shots for illustration). 

I am not sure how to transfer image data stored as data in the database into files of their native type, i.e. how is jpg data, stored in the database as binary data extracted into a .jpg file?  Similarly, how is a .jpg file stored (or inserted) from a file into the database 

Thanks in advance for your help.

Ryk

[JD_war_eagle]

Hi ryk,

This looks like a duplicate post.  Please see my response in: http://forums.ni.com/t5/LabWindows-CVI/Storing-and-Retrieving-JPEG-pictures-in-an-MS-Access-database....