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-22 Thread Gregory Ewing
On Thu, 20 May 2010 02:45:10 -0700 (PDT), Jimoid jimmy.cul...@gmail.com declaimed the following in gmane.comp.python.general: 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

Re: Reading data from a Microsoft Access 2003 database

2010-05-21 Thread Adam Tauno Williams
On Thu, 2010-05-20 at 22:58 -0700, Dennis Lee Bieber wrote: On Thu, 20 May 2010 02:45:10 -0700 (PDT), Jimoid jimmy.cul...@gmail.com declaimed the following in gmane.comp.python.general: I've now had a closer look at both pyODBC and mxODBC and it seems to me that they both require the

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

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 --

Re: Reading data from a Microsoft Access 2003 database

2010-05-19 Thread Simon Brunning
On 19 May 2010 10:28:15 UTC+1, Jimoid jimmy.cul...@gmail.com wrote: 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

RE: Reading data from a Microsoft Access 2003 database

2010-05-19 Thread Ahmed, Shakir
-Original Message- From: python-list-bounces+shahmed=sfwmd@python.org [mailto:python-list-bounces+shahmed=sfwmd@python.org] On Behalf Of Simon Brunning Sent: Wednesday, May 19, 2010 6:13 AM To: python-list Subject: Re: Reading data from a Microsoft Access 2003 database On 19 May

Re: Reading data from a Microsoft Access 2003 database

2010-05-19 Thread Les Schaffer
Jimoid wrote: 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. this worked like a charm for me:

Re: Reading data from a Microsoft Access 2003 database

2010-05-19 Thread Adam Tauno Williams
On Wed, 2010-05-19 at 08:05 -0400, Les Schaffer wrote: Jimoid wrote: 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

Re: Reading data from a Microsoft Access 2003 database

2010-05-19 Thread Adam Tauno Williams
On Wed, 2010-05-19 at 02:28 -0700, Jimoid wrote: 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.

Re: Reading data from a Microsoft Access 2003 database

2010-05-19 Thread Les Schaffer
Adam Tauno Williams wrote: The OP: I use Ubuntu 64 bit woops, my bad ... -- http://mail.python.org/mailman/listinfo/python-list