What do I need to read Microsoft Access databases using Python?
Question: How can I access Microsoft Access databases in Python? With SQL?

I'd prefere a solution that works with Linux, but I could also settle for
Windows.

I only require read access.


Answer: On Linux, MDBTools is your only chance as of now.
[[disputed]](http://stackoverflow.com/questions/853370/#comment53931912_15400363)

On Windows, you can deal with mdb files with pypyodbc.

To create an Access mdb file:

    
    
    import pypyodbc
    pypyodbc.win_create_mdb( "D:\\Your_MDB_file_path.mdb" )
    

[Here is an Hello World
script](https://code.google.com/p/pypyodbc/wiki/pypyodbc_for_access_mdb_file)
that fully demostate pypyodbc's Access support functions.

Disclaimer: I'm the developer of pypyodbc.

