Linux guy seeks help w/MS Access/Python

[Alex Martelli]

"Quasimodo" <KILLzdramboSPAMMERS at zdnetmail.com> wrote in message
news:8nrn32$22ai$1 at newssvr03-int.news.prodigy.com...
> Yes, using any of the ODBC modules you have full SQL functionality from
> Python to Access.

Note: Microsoft Access is an application for developing front-end
access to several (mostly SQL) possible database engines.  One such
engine, called 'JET', is normally the one distributed with Microsoft
Access (it's also distributed with other Microsoft products, including
ones available for free download), and (partly thanks to Microsoft's
usual muddled marketing dept) is often confused with Access itself.

See my other post to this thread for Python connection to Microsoft
Access itself, which is what Mr. Wagner asked for (although it is
quite likely that it's not what he really wants/needs).

If what one wants is 'SQL functionality' regarding .MDB files (which
is where JET keeps its databases), ODBC is one approach (and, with
the mxODBC module, has the advantage of compliance with the Python
DB API).  But other approaches, signally ADO (also easily and fully
accessible to Python via the win32com part of Hammond's win32all
Windows Extensions), may well be preferable (just forget the older
DAO, except for a silent curse to the usual MS marketeers which
managed to give it a name so easily confusable with ADO...!).


Alex