Re: Reading data from a Microsoft Access 2003 database

2010-05-25 Thread Jimoid
This is perfect if the python ODBC driver can read the .mdb without the need for it to be running elsewhere. Thanks all for your help. -- http://mail.python.org/mailman/listinfo/python-list

Re: Reading data from a Microsoft Access 2003 database

2010-05-20 Thread Jimoid
I've now had a closer look at both pyODBC and mxODBC and it seems to me that they both require the database to be running to be able to query it. Is this correct? If so I think I will have to use mdb-* as the database I want to query is not running. Cheers, Jimmy -- http://mail.python.org/mailma

Re: Reading data from a Microsoft Access 2003 database

2010-05-20 Thread Jimoid
Thanks to all for your helpful suggestions. So far I have installed and played around with mdbtools, and it appears that I can use this from the shell to extract the information I need, e.g. mdb-export for dumping an entire table or mdb-sql to run a query. I am also interested by mxODBC and pyodbc

Reading data from a Microsoft Access 2003 database

2010-05-19 Thread Jimoid
Hi All, I use Ubuntu 64 bit and need to develop a programme (ideally in Python) to work on data that is contained in a Microsoft Access 2003 database. I do not need to modify the database, simply read a few columns of data from some tables. Google hasn't been able to offer me a suitable solution