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? |
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 |