Read binary data from a MDB-file running under LAMP
- by BusterX
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 Data according
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 0x00
I 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?