If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Long binary data" in Access db
I have an off-the-shelf app that uses an Access database as its
backend. One of the tables contains a field with an "OLE Object" datatype. I'm writing some reports against this database, and I believe this field contains data I need. When I view the table in datasheet view, all I can see in this field is the string "Long binary data". So, I've got the problem of needing to extract data from this field, but I don't know what format the data is in, or how the app inserts data to begin with. If I can extract the binary data intact, I may be able to pick it apart and find what I need. I'm looking for a solution that lets me get at the data for the whole table, so an export of the whole table including the binary data would be fine. I'm not a VB or ASP coder, but if code is needed for this I can probably copy code samples and make simple modifications to suit my task. Is there any hope of extracting this data? |
#2
|
|||
|
|||
The way the data is stored is determined by that OLE Object. You could try to
reverse engineer the format. Another way is perhaps trying to instantiate the object, and use the interfaces it supports. "Jerry" wrote: I have an off-the-shelf app that uses an Access database as its backend. One of the tables contains a field with an "OLE Object" datatype. I'm writing some reports against this database, and I believe this field contains data I need. When I view the table in datasheet view, all I can see in this field is the string "Long binary data". So, I've got the problem of needing to extract data from this field, but I don't know what format the data is in, or how the app inserts data to begin with. If I can extract the binary data intact, I may be able to pick it apart and find what I need. I'm looking for a solution that lets me get at the data for the whole table, so an export of the whole table including the binary data would be fine. I'm not a VB or ASP coder, but if code is needed for this I can probably copy code samples and make simple modifications to suit my task. Is there any hope of extracting this data? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Generating a one-record ouptut from a query-based data access page | Elizabeth S | New Users | 0 | February 15th, 2005 05:15 PM |
is Access 2003 any better than XP? | Gorb | General Discussion | 4 | November 11th, 2004 09:44 PM |
VBA Code problem error 9 | Speedy | General Discussion | 19 | October 15th, 2004 09:05 PM |
Troubleshoot the SendObject method | Nikky_Pickles | General Discussion | 1 | August 30th, 2004 07:40 AM |
Display Binary data ( an OLE object field in Access database) to Excel Cell | Koo | Worksheet Functions | 0 | October 9th, 2003 09:43 AM |