Does anyone know of a method to convert a File Geodatabase Table into an Access 2007 Table programmatically. I have been trying using the PYODBC library and a series of insert statements but am having difficultly with some of the data types and NULL. Basically an unload to Access.
Asked
Active
Viewed 3,030 times
8
-
All the ESRI literature I have seen only covers the reverse, getting ACCDB files into ArcMap using an OLE DB connection, so great question! – blah238 Dec 09 '11 at 18:33
-
Do you have the Data Interoperability Extension or FME? If so that would probably be a lot easier to use than PYODBC. – blah238 Dec 09 '11 at 18:52
-
1I've not tried this but can't you simply use the Table to Table tool? Set up your OLE DB connection to Access in ArcCatalog then use the Table to Table geo-processing tool? – Hornbydd Dec 10 '11 at 17:45
-
Hronbydd - I don't believe that ESRI provides write capabilities to an ole db connection string for Access 2007 - i have tried this and the tool failed, that is why i have begun going down the PYODBC path. – dklassen Dec 12 '11 at 16:58
2 Answers
2
Untested, but this should work: Create a personal geodatabase, import file-gdb into that, then open the resulting .mdb in Access 2007 and upgrade it from the Access side. If any of the source feature classes exceed 2gb you'll need to do add some logic for splitting things into pieces and recombining.
matt wilkie
- 28,176
- 35
- 147
- 280
-
Yes this would work, unfortunately i want to add my table to an existing working database. We have an ongoing project that tables need to be added to monthly and this DB is already built in the ACCDB format. Thanks – dklassen Dec 16 '11 at 23:33
-
@dklassen, in that case what about using table-to-table to export and then suck them in on the Access side as linked tables? If the table names are predictable or static every time the Access db is opened they'll be current. – matt wilkie Dec 20 '11 at 05:13
1
Along the lines of this question, I wonder if you could pull the table out of the file geodatabase into a text file, then programmatically slurp the text file into Access? Here is a post on Stackoverflow to check out and here is a blog post on using Python with ADO.
Chad Cooper
- 12,714
- 4
- 46
- 87
-
This is basically what i have created. I have used the pyodbc library to connect to the Access DB and then looped through the File GDB table and create a series of Insert SQL Statements for the Access DB. Then execute them. Seems to work fine, but keeping track of all the possible data types is a bit overwhelming. – dklassen Jul 06 '12 at 06:00