On Tue, 06 Sep 2005 13:45:09 -0600, Jim Vickroy <[EMAIL PROTECTED]> wrote:
> > >I am not a MS Access user, but I have successfully used the information at > >http://www.connectionstrings.com/ > >to access the information in Excel files via ODBC. > I'd like to comment just for completeness, in case someone reads these archives in the future. ODBC does allow you to gain acess to the INFORMATION in an Access database. It uses the Jet database engine to read the tables and queries. However, that's all it can get to. The macros, forms, reports, and VB code are NOT part of the database per se. They are strictly part of the Access application. In order to gain access to them, you have to use COM to fire up Access.Application, just as Bob suggested. By the way, Bob, it isn't necessary for you to fetch the Access application version number to do the dispatch. You can do this: a = win32com.client.Dispatch( "Access.Application" ) Through the magic of the registry, Access.Application is a "symbolic link" to Access.Application.10 (or whatever), which is itself a symbolic link to the UUID of the Access application. -- Tim Roberts, [EMAIL PROTECTED] Providenza & Boekelheide, Inc. _______________________________________________ Python-win32 mailing list Python-win32@python.org http://mail.python.org/mailman/listinfo/python-win32
