Re: Dealing with Excel

2005-10-19 Thread Francois Lepoutre
Robert Hicks wrote: > I need to pull data out of Oracle and stuff it into an Excel > spreadsheet. What modules have you used to interface with Excel and > would you recommend it? > > Robert > http://sourceforge.net/projects/pyexcelerator/ http://sourceforge.net/projects/pyxlwriter/ We use the l

Re: MS SQL Server/ODBC package for Python

2005-04-18 Thread Francois Lepoutre
Hi Peter Running your benchmark, I ran into a couple of interesting points. Using mx.ODBC, my times were 0.54 seconds and 6.56 seconds respectively, while using adodbapi my results are 3.55 seconds and 25.9 seconds respectively. mx.ODBC is faster with the simple query you provide. We agree on figu

Re: MS SQL Server/ODBC package for Python

2005-04-16 Thread Francois Lepoutre
Peter, May my I apologize for knocking against your information, as well. > For what it is worth, my experience is as follows: Using a PIII > 550MHz, 256MB RAM, running WinNT 4.0 and Python 2.3.4 and connecting > to a Sybase Adaptive Server Anywhere 8.0 database, mx.ODBC took > approximately 8 wal