| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| converting continuous data into binary data | Excel Worksheet Functions | |||
| New to accessing mysql dbase in excel vba | Excel Programming | |||
| Import data from mysql on a web server | Excel Programming | |||
| Import data from mysql | Excel Programming | |||
| importing data from MySQL | Excel Programming | |||
Hybrid Mode
