[python-win32] driving MS Access from python

[Phill Atwood]

Tim,

Thanks. I've downloaded and installed adodb for Python.  But I guess I 
need to install mxODBC as well.  But I'm not quite understanding the 
docs I'm reading on how to do this.  It seems very complex....

Phill

Tim Roberts wrote:
> On Mon, 13 Mar 2006 15:28:58 -0500, Phill Atwood <me at phillatwood.name>
> wrote:
>
>   
>> Thanks.  This seems like a good idea.  I noticed also ADOdb for Python. 
>> Would this work do you know?  Since I'm doing win/ms access I think I'll 
>> need to use mxodbc but I don't know how to install that on Windows.
>>
>> In your example below it is not clear (to me) how to get the dimensions 
>> of the recordset and navigate thru (eg. print) all the resultant 
>> fields.  Is there something similar to the ADOdb for
>> Python
>>
>>     
>
>
> One of the issues with Access is that there are an "embarrassment of
> riches" of methods to get to an Access database on Windows.  You have
> ODBC directly, mxodbc, Jet, DAO, Jet via ADODB, ODBC via ADODB, DAO via
> ADODB.
>
> ADODB is a very good way of doing it.  One of the advantages is that the
> same code works for Postgres or MySQL; you just change the connection
> string (although that's mostly true for ODBC, too).  Plus, by creating
> an ADOX.Catalog object, you can stroll through the metadata as well. 
> You can fetch the list of tables, and the fields within the tables, and
> so on.
>
>