Dealing with Excel

Larry Bates larry.bates at websafe.com
Wed Oct 19 16:50:34 CEST 2005


Using ODBC interface to Oracle Excel can do this without
any external (Python) program.  Just:

1) Create a ODBC DSN that interfaces with Oracle
2) In Excel do Data-Get External Data-New Database Query
3) Tell Excel what tables/columns/order/filtering you want

You can even save the Database Query for later re-use.
If you want, you can automate this process using Python
COM+ interface to Excel.

Larry Bates

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
> 



More information about the Python-list mailing list