Read binary data from a MDB-file running under LAMP
Posted
by BusterX
on Stack Overflow
See other posts from Stack Overflow
or by BusterX
Published on 2010-06-05T09:32:03Z
Indexed on
2010/06/05
9:42 UTC
Read the original article
Hit count: 259
I need to be able to connect to an MDB-file in a LAMP-environment (running on Linux) and ultimately insert converted data into a Mysql db.
The data I need to access is stored as a BLOB (
Long Binary Dataaccording to Access) in the MDB file. I have not yet been able to actually have a look at the data but I have been told that the BLOB consists of byte strings. Something along the lines of:0x1c 0x10 0x27 0x00 0x00I need to parse the byte strings and convert these to a format that is
human readable. I do have access to
the documentation that explains the
various byte strings.
So this is really two questions:
- How do a get access to the MDB file via PHP* (running under LAMP) and read the BLOB (I do not have access to a Windows-platform)?
- What would be the best way to parse the binary data (in PHP*) once I am able to connect to the MDB-file?
*Or are there other methods/languages that are more appropriate?
© Stack Overflow or respective owner
