ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Problem accessing binary data from mysql data base (https://www.excelbanter.com/excel-programming/391872-problem-accessing-binary-data-mysql-data-base.html)

Don

Problem accessing binary data from mysql data base
 
I am writing a macro using ADODB types to connect to a mySql database and
retrieve data. It works fine for fields in the record set that are varchar
but my database has two fields that store long text strings differently. One
is a blob (and in excel the recordset.fields(blobfield).type is 205. The
other is a binary text field (again - excel
recordset.fields(binarytextfiled).type is 204. I know both fields contain
ascii.

I had hoped I could extract data via getchunk methods but this fails. Any
suggesstions would be welcome.


All times are GMT +1. The time now is 01:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com