Script to Filter and export an Access 2007 database using a Feature Class.

Discussion created by jiphoc on Apr 22, 2014
Latest reply on Apr 23, 2014 by jamesfreddyc

I was wondering if anyone could help me. I am relatively new to python so please keep that in mind with any replies.

I am writing a script which will be exporting from a 1.2GB Access 2007 file (about 30 tables). However I want to filter each table within the Access file by a field in a separate feature class (stored in a file gdb). The field is unique and will be unique in each Access table. The result will be an exported set of files with the tables (or whatever tables are selected at the time) with only the records found using the gdb as a filter. The format of the export is preferable excel or as a csv.

I am trying to avoid having to convert the feature class to an access or SQL table if possible, however if it cannot be avoided to get the ideal result then so be it. Just for reference I am using the pyodbc module and the Microsoft Access Drive to connect to the Access file.

Thanks in advance for any help and I am happy to answer any questions you may have that could assist.