Array of images into single Access database field

[jkarl]

Hello all,

I have this pie in the sky idea to save an array of images to a single Access "Memo" datatype data field by constructing a string using three functions:

1) "IMAQ Flatten Image to String.vi"

2) "Array To Spreadsheet String.vi"

3) "Spreadsheet String to Array.vi"

First I construct an array of strings containing images that have been flattened using the "IMAQ Flatten Image to String.vi".  Next I take the resulting array and use the "Array To Spreadsheet String.vi" to create a single string that is than inserted into an Access "Memo" database field.  Labview has no problem storing and retrieving the data from the "Memo" format as a string, the problem is when using the "Array To Spreadsheet String.vi" the data becomes corrupt.

I have also thought about ZIPing the image directory and storing it into the database as an "OLE" type.  I can zip the images fine but do not know how to load the zipped result into labVIEW 2010 and then push it into ACCESS,  the images are small, only ~50KB

Cheers,

Karl

[BlueCheese]

The flattened string of the image contains non-printable characters and might not be compatible with limitatious of the spreadsheet format. Perhaps you could use Base64 encoding on the string first?

Eric

[jkarl]

Hi BlueCheese,

Thanx for the reply.

Actually I figured out what to do just after the post.  I simply concatenate a fiducial after each string image and then concatenate all images into a single string (see attached code) and then reverse the process reading back from the database, works perfectly.

Regards,

Karl