[DB-SIG] Python query

[Marcos Sánchez Provencio]

You must use COM and have access installed:

from win32com.client import Dispatch
strDbName = 'Put the path to your database here '
objAccess = Dispatch("Access.Application") 
#objAccess.Visible = False 
objAccess.OpenCurrentDatabase(strDbName) 
objDB = objAccess.CurrentDb() 
macro = objDB.containers("Scripts").Documents['macroName'] 

etc.

Please check vba docs. I have hacked this example from the web and
cannot check it from linux.

El mar, 06-09-2005 a las 09:12 +0530, Arun Tyagi escribió:
> Hi,
> 
> i want to know how can we execute MS Access macro through python code.
> 
> please help.Its very urgent.
> 
> Regards
> Arun
> 
> _______________________________________________
> DB-SIG maillist  -  DB-SIG at python.org
> http://mail.python.org/mailman/listinfo/db-sig
-- 
Marcos Sánchez Provencio <marcos at burke.ath.cx>