On Mon, 13 Mar 2006 15:28:58 -0500, Phill Atwood <[EMAIL PROTECTED]> 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. -- Tim Roberts, [EMAIL PROTECTED] Providenza & Boekelheide, Inc. _______________________________________________ Python-win32 mailing list Python-win32@python.org http://mail.python.org/mailman/listinfo/python-win32