Re: Anything available that can read Microsoft .MDB files from Python?

Steve Holden wrote:
Terry Reedy wrote:

<kyosohma@xxxxxxxxx> wrote in message news:1174334517.125928.274140@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
| I've read .MDB files using ODBC. I don't know how big your files are,
| but I had a file with almost 3000 rows and I was able to fetch it in
| 1-2 seconds. If you want to give it whirl, you just need to create an
| ODBC connection and then do the following:

I'll just mention that OpenOffice.org Base can make ODBC connections and output in several formats. Don't know if their ODBC works with .MDB.

I seem to remember I actually managed to open an MDB file with the Open Office database component (but that was on Windows, so I can't guarantee it will work on Linux).

That works fine on Windows, because OpenOffice can use Jet, the Access engine. Don't know if it would work on Linux. Probably not.

I need to read about 10,000,000 records, and running them through an
OpenOffice spread*** probably isn't a good approach. There are quite
a few tools for dealing with small Microsoft Access databases in memory, but
they don't scale.

MDBtools would be the right answer, if it worked. I have some questions
out on the MDBtools forum, trying to work around some build problems.
MDBtools hasn't had a release in three years, and it won't build with
Fedora Core 6.

John Nagle
.