FGDB to Excel

[Lew]

Hey pythoneers,

Does someone have a script for exporting from a FGDB tables to
Excel?

Currently, I write data from FGDB to PGDB first, then export to an
Excel table with an ODBC connection.

Thanks
Lew

[pd3244]

Have you tried 'import csv' module ? 

 

http://www.doughellmann.com/PyMOTW/csv/

[Greentree, Lew FLNR:EX]

Hi Doug,

 

Thank you for responding to my question.

 

Yes, I have used export to csv as an intermediate step when exporting from FGDB.  Just wondering if there is a more direct method.

 

Cheers,

Lew

[tarkenton]

Hey Lew

I wrote a module a while back called export2Excel.  The module is in the script warehouse under:

Utility_Misc\Ready\xlutils

For instructions on how to use it see:

https://sites.google.com/site/bcgeopython/examples/export-esri-table-to-excel

I recommend using version 3 as it has been modified to put date fields into excel as dates as opposed to as strings.

Hope this helps

Kevin

[Denis Potvin #5]

Lew, I've used Kevin's script successfully without much stress