How to get to table in Access accdb file?

Discussion created by trowekamp on Mar 30, 2011
Latest reply on Dec 7, 2011 by dk10
I would like a python script to use a table from an Access 2007 database as an input to a geoprocessing tool.

I am importing adoconstants and opening a connection to the database from python. I can get a recordset from the open connection using a table name - how do I pass that into a tool?

I'm just starting to work on this but before I go too far would like to know if I'm trying to do something that just won't work. I need to write something that will work in 9.3.1.

I'd appreciate any help/clarification or sample code.