Hi, I've been writing some Microsoft Excel VBA to retrieve information on my orders. I use the information to generate some custom emails.

Using the MySQL ODBC driver, and by creating an ADODB.Connection, I'm able to retrieve various order fields into cells in Excel. I'm having a problem though with attributes since they are stored in a BLOB field. I've been reading that I should be able to use a ADODB.Stream object to retrieve the BLOB data, but I'm not having a lot of luck (I'm not that fluent in VBA).

Has anyone ever done this or do you have any tips?

Thanks in advance.