Hi,
I would like to know how to display the OLE binary data as a string in MS Access.



To elaborate, I am importing contact details from MS Outlook as a link table in Access. The ID field (EntryID) comes across as OLE Object data type and displays as "Long Binary Data" when viewing the data. As an OLE data type cannot be used in relationships/as a key, I need to view/convert this data to a string (1's and 0's or hex – I don't really care).

Once I have the EntryID as a string I can link tables in access to contacts managed in Outlook.

When I view the data using another software program (FME) I can view the OLE data as a string such as:
"EF000000198262C0AA6611CD9BC800AA002FC45A060007000 000040000011BF3AE12040000031F7D9602"
– this is the sort of thing I would like to see/do within Access.

Can anyone help?

Cheers.