Copy data from MS Access to MS Excel using Python

Discussion created by BrokenLegMike on Oct 2, 2011
Latest reply on Oct 4, 2011 by BrokenLegMike
I've been spending the better part of the weekend trying to figure out the best way to transfer data from an personal geodatabase feature class into an Excel sheet using Python. I've found a few modules that may help (execsql, python-excel), but I'm not sure what the best approach should be.

All I need to do is copy 4 columns of data from access to excel and then format the excel. I have the formatting part solved.

Should I:

  • Iterate through the rows using a cursor and somehow load the rows into excel?

  • Copy the columns from access to excel?

  • Export the whole access table into a sheet in excel?

Thanks for any suggestions.