How to get to table in Access accdb file?

[TereseRowekamp]

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.

[DarrylKlassen]

Hello,

I am also looking for a way to transfer data between Python and an Access 2007 database (ACCDB).  I would specifically like to find a tool to export from a File GDB directly to an ACCDB.  I have began writing some PY code to do this, but so far have run into many issues.  Mostly dealing with the various data types and translating them into well formed SQL statements.

If anyone has any ideas or has done this before, i would appreciate the help.