Popular recipes by Grant Paton-Simpson http://code.activestate.com/recipes/users/4074475/2008-03-01T07:15:52-08:00ActiveState Code RecipesExtraction and manipulation class for Microsoft Access (Python)
2008-03-01T07:15:52-08:00Grant Paton-Simpsonhttp://code.activestate.com/recipes/users/4074475/http://code.activestate.com/recipes/528868-extraction-and-manipulation-class-for-microsoft-ac/
<p style="color: grey">
Python
recipe 528868
by <a href="/recipes/users/4074475/">Grant Paton-Simpson</a>
(<a href="/recipes/tags/database/">database</a>).
Revision 2.
</p>
<p>Class for extracting and manipulating data from Microsoft Access - identifying tables, getting recordsets, iterating through the results, counting rows, getting field names, getting index information, deleting indexes, and adding and deleting relationships.</p>
Class for writing content to Excel and formatting it (Python)
2007-09-07T03:08:02-07:00Grant Paton-Simpsonhttp://code.activestate.com/recipes/users/4074475/http://code.activestate.com/recipes/528870-class-for-writing-content-to-excel-and-formatting-/
<p style="color: grey">
Python
recipe 528870
by <a href="/recipes/users/4074475/">Grant Paton-Simpson</a>
(<a href="/recipes/tags/database/">database</a>).
Revision 4.
</p>
<p>Class for creating Excel spreadsheets - esp writing data and formatting them. NB OpenOffice Calc will be easily able to open the outputs too.</p>