Prev: Quality Indian Dresses At Reasonable Prices
Next: remove elements incrementally from a list
From: Jimoid on 19 May 2010 05:28
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 to this
problem, and although there are some references to this problem in the
archives of this group, they are mainly very old and I wonder if there
is anything more recent that members could suggest to me?

Python would be my language of choice, however if someone has any
other suggestions then I'm open to ideas.

TIA,

Jimmy
From: Simon Brunning on 19 May 2010 06:13
On 19 May 2010 10:28:15 UTC+1, Jimoid <jimmy.cullen(a)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 tables.

mxODBC might well be what you are looking for,

--
Cheers,
Simon B.
From: Les Schaffer on 19 May 2010 08:05
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:

http://code.activestate.com/recipes/528868-extraction-and-manipulation-class-for-microsoft-ac/

Les
From: Ahmed, Shakir on 19 May 2010 07:47

-----Original Message-----
From: python-list-bounces+shahmed=sfwmd.gov(a)python.org
[mailto:python-list-bounces+shahmed=sfwmd.gov(a)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 2010 10:28:15 UTC+1, Jimoid <jimmy.cullen(a)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 tables.

mxODBC might well be what you are looking for,

--
Cheers,
Simon B.
--

Or you can use pyodbc
DBfile = '/path/*.mdb
conn = pyodbc.connect('DRIVER={Microsoft Access Driver
(*.mdb)};DBQ='+DBfile, autocommit=True)
cursor = conn.cursor()

Thanks
Shakir

From: Adam Tauno Williams on 19 May 2010 08:17
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 from some tables.
>
> this worked like a charm for me:
> http://code.activestate.com/recipes/528868-extraction-and-manipulation-class-for-microsoft-ac/

The OP: "I use Ubuntu 64 bit"

Does something that contains "import win32com.client" work on anything
other than Windows?
--
Adam Tauno Williams <awilliam(a)whitemice.org> LPIC-1, Novell CLA
<http://www.whitemiceconsulting.com>
OpenGroupware, Cyrus IMAPd, Postfix, OpenLDAP, Samba

 |  Next  |  Last
Pages: 1 2 3
Prev: Quality Indian Dresses At Reasonable Prices
Next: remove elements incrementally from a list