Reading and Writing MS Excel and MS Access Files Using Python

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Reading and Writing MS Excel and MS Access Files Using Python

Georg Maubach
Dear Listers,

We need to read and write MS Excel and MS Access files using Python. Is
there a module for handling of file of the MS Office product family?

If its not, how could we read CSV (comma separated value) files using
Python?

Best regards

Georg Maubach
Market Analyst
Reply | Threaded
Open this post in threaded view
|

Re: Reading and Writing MS Excel and MS Access Files Using Python

Marta García-Granero
Hi Georg

Although this is a good place to ask about SPSS14&Python, I believe
this question could find more responses if addressed to the Python
Forum too:

http://www.spss.com/fusetalk/forum/categories.cfm?catid=9&entercat=y

GM> We need to read and write MS Excel and MS Access files using Python. Is
GM> there a module for handling of file of the MS Office product family?

GM> If its not, how could we read CSV (comma separated value) files using
GM> Python?

(I, for one, am still stuck with SPSS 13, and know nothing, absolutely
nothing - it's a pity - about Python).

Regards,
Marta
Reply | Threaded
Open this post in threaded view
|

Re: Reading and Writing MS Excel and MS Access Files Using Python

Peck, Jon
As Marta, points out, the Python user group has a lot of people poised at their keyboards to answer Python questions.  Most of them, of course, will not know anything about SPSS.

For reading Access and Excel files, you might consider the Python ODBC interface.  It works very much like the spssdata module that brings data from SPSS to your Python module (this is not an accident!).  You can find details and some examples in one of the HOW TO documents on the Python web site.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Marta García-Granero
Sent: lunes, 21 de agosto de 2006 4:43
To: [hidden email]
Subject: Re: [SPSSX-L] Reading and Writing MS Excel and MS Access Files Using Python

Hi Georg

Although this is a good place to ask about SPSS14&Python, I believe
this question could find more responses if addressed to the Python
Forum too:

http://www.spss.com/fusetalk/forum/categories.cfm?catid=9&entercat=y

GM> We need to read and write MS Excel and MS Access files using Python. Is
GM> there a module for handling of file of the MS Office product family?

GM> If its not, how could we read CSV (comma separated value) files using
GM> Python?

(I, for one, am still stuck with SPSS 13, and know nothing, absolutely
nothing - it's a pity - about Python).
[>>>Peck, Jon] We are working on a mind meld, Marta.  :-)

Regards,
Marta