Re: Read static .MDB files?

[baku]

Quick search on the domain of doom came up with:

http://msdn.microsoft.com/library/default.asp?URL=/library/books/dnjet/c1_body_16.htm

Disclaimer: I didn't browse too deep (This site dislikes Netscape a bit!) so I don't know if they actually provide enough detail for implementation; however, this seems to be the best bet.

That'll bring you into their manual on the "Jet" (aka "Access") file format; scroll down in the left frame to find the appropriate chapters. I don't know of a module to do this already, but a DBD::MDB object would probably be the way to go (possible derived from DBD::CSV?)...?

You might also want to look into the formats used by e.g. MS Word; they (Microsoft) tend to use a chunk-structured file format (called OLE like everything else?) similar (...) to PNG or TIFF, so Access likely is quite similar; work toward parsing Word files might have a lot of useful info. for you. One starting-point might be WV

Another option might be some kind of MDB2CSV|XML filter :-)

Good luck!

---

Amendment: Today's post has an actual ref to an MDB2CSV converter, which should be 'importable' to DBD::CSV. Voila! Thanks to jeroenes for the info